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
152015Jun

Q-Tip #10 – Waterfall Chart in Qlik Sense

Don’t you wish Qlik Sense bar charts had the Bar Offset feature, similarly to QlikView bar charts? We surely do. How else can you develop a waterfall chart? Well, then if you think about it long enough, maybe it’s not entirely impossible… The following explanation provides detailed steps to developing your own waterfall chart in Qlik Sense….

Read More