92017May

Q-Tip #17 – The Curious Case of a Wildcard Load and a Join

It’s been a while since I had a chance to write a blog article… I can’t complain though, because preparing and delivering the Masters Summit for Qlik in Munich was a lot of fun. I also took a few days off and jumped to Prague, which was awesome! Interesting discovery (at least to myself) – in Prague,…

Read More
202016Dec

Q-Tip #16 – What’s Special About Those Derived Fields

Ever since the introduction of Derived Fields in Qlik Sense, I was curious – what’s so special about them? Are they different from any other fields that are stored in your data set? Are they stored or calculated on the fly? Do they work equally well in Chart dimensions, in Filters, and in Set Analysis…

Read More
272016Oct

Q-Tip #15 – Excluding the Excluded

It’s been a while since I found an interesting topic, worthy of a blog article… This Q-Tip originated from a question that we received at the Masters Summit for Qlik in Ausitn, TX. Here is the question: Hmm… at first I was puzzled and couldn’t even come up with a direction for the possible solution….

Read More
162016May

Q-Tip # 14 – AGGR() and Synthetic Dimensions

Hi everyone – QlikView and Qlik Sense developers, beginners and experts, those who usually ask questions on Qlik Community and those who usually answer them. Today I’d like to talk about one of the most mysterious issues of all (at least, this is how it looks like on the Qlik Community forums) – using the AGGR()…

Read More
292015Dec

Q-Tip #13 Happy New Year, New Calendar Functions, and New Behaviors!

Apologies to my blog followers for a long period of silence. Needless to say, I’ve been busy – among other things, working on converting our Masters Summit for QlikView into all new, freshly re-designed Masters Summit for Qlik. The difference may sound subtle, but in reality, a lot of preparation work is happening as we speak….

Read More
152015Sep

Q-Tip #12 – Peek() or Previous() ?

This article was sparkled by this discussion thread on Qlik Community. The question was: how to calculate the difference between dates that are stored in consecutive rows of a table? Three answers to the question suggested three different approaches. Let’s analyze what’s right, what’s wrong and does it matter at all? We typically use values from…

Read More
192015Aug

Q-Tip # 11 – So How Many Customers Make Up Most of Your Sales?

You obviously know the Pareto principle – 80% of outcomes are driven by 20% of efforts. QlikView offers numerous tools that allow visualizing the Pareto principle. Here are just a few that come to mind: It’s quite easy to create a Pareto report and show cumulative contribution of Customers (Suppliers, Products..) to the overall %…

Read More
72015Aug

News: QlikView Your Business – the wait is over!

Great news for everybody who’s been waiting for the release of our new book, QlikView Your Business. The book is officially out. I just received my author copies. Amazon shows the book “in stock”, and as far as I know, they are shipping pre-orders now. At the time this article is being written, Amazon still…

Read More