The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
146 FOLLOWERS
The Qlik Fix is a blog dedicated exclusively to QlikView tips, tricks and tutorials, written by Barry Harmsen. He is a Business Intelligence Consultant at Bitmetric in the Netherlands, where he specializes in QlikView (and Business Intelligence, Data Warehousing and Performance Management in general). As a QlikView consultant, he has built up an extensive library of QlikView tips, scripts,..
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Hi there!
As of February 28th 2023 we’ve moved all our blogging activities to our Bitmetric company blog (https://bitmetric.nl/blog). Why? Because it just seemed more practical than running two separate blogs (also, it looks much nicer!). Check it out, we’ve already have more than 50 posts there, including our weekly Qlik certification test prep questions (follow our LinkedIn company page if you want to participate in the weekly questions).
We’ll gradually copy and refresh some of the content from the QlikFix blog to the Bitmetric Blog. Of course, we’ll keep this site running in archive mode ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
The Masters Summit for Qlik is the premier advanced training event for Qlik Sense and QlikView. Since 2013 more than 1200 developers from all over the world have taken their Qlik skills to the next level at one of our events.
After 2 years of online trainings, we’re glad to return to in-person events, starting in the beautiful city of Madrid in September 2022.
Join Rob Wunderlich, Oleg Troyansky, Bill Lay, Nick Webster and Bitmetric‘s Barry Harmsen for 3 days of Qlik deep dives, peer networking, ready to use resources and much more.
Are you ready to take your Qli ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
The growth of e-commerce during the pandemic
Something completely different from our usual posts, on Thursday July 7th at 3 PM CET we’re organizing a webinar about Retail Analytics at IKEA: “The growth of e-commerce during the pandemic”. Discover how the Covid pandemic became a turning point and helped this global furniture company accelerate it’s e-commerce growth.
Speakers
Bert Ipema
Digital Product Leader Shared Data & Technology at IKEA
Angelika Klidas
Manager Operations & Data Literacy Evangelist at Bitmetric
Program
Opening and introductions
Bert ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
The correct answer is D: Finland, New Zealand and Poland
Many times you will have to do some form of data transformation to deliver the required results. And in many of those times you will probably find yourself using Subfield(), see Qlik prep question 16 , or in this instance Wildmatch().
Wildmatch() is a great tool to find values in a field containing a certain word or hav ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
The correct answer is C: 28% of the CustomerID’s have never placed an order
To validate and check the quality of the data model which you have just created, the data model viewer is an important tool. One of the things you can check here is the subset ratio. The subset ratio is the percentage of present distinct values within that table compared to the total distinct values o ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
The correct answer is B: Peek()
Since none of the answers provided a “fix it in the source” we are left with Peek() as the best solution for this problem. The main difference in these answers is that Peek() will look at the output table whereas Previous() will evaluate the input table. So if we compare those two answers we find that Previous() is not ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
The correct answer is D: FirstSortedValue()
Understanding the question and understanding what answer the examiner wants to hear on a certification exam are sometimes two different things. Qlik certication exam questions often contain some ambiguity, and as we’re striving for realism here, we include this in our questions as well. In the case of this question the correct answer is First ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
The correct answer is A: Date#()
In this case we have to use Date#() to tell Qlik to interpret the Date field as a Date value. This is different from Date() in which we tell Qlik how to format the date value.
So what’s is the difference?
To explain this, we first need to understand that the date field in Qlik has a dual value. All date ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
This is typically a relatively tough question, but fortunately everyone who participated is above average!
The correct answer is D
You may wonder why this is a tough question, that’s because in the past both single and double quotes would be evaluated as a search expression by Qlik. This has lead to single and double quotes being used interchangeably, while formally only the double quotes ..read more
The Qlik Fix | QlikView & Qlik Sense tips, tricks and tutorials
2y ago
The Masters Summit for Qlik is the premier advanced training event for Qlik Sense and QlikView. Since 2013 more than 1200 developers from all over the world have taken their Qlik skills to the next level at one of our events.
After 2 years of online trainings, we’re glad to return to in-person events, starting in the beautiful city of Madrid in September 2022.
Join Rob Wunderlich, Oleg Troyansky, Bill Lay, Nick Webster and Bitmetric‘s Barry Harmsen for 3 days of Qlik deep dives, peer networking, ready to use resources and much more.
Are you ready to take your Qli ..read more