May 16, 2016

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() […]
December 29, 2015

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. […]
September 15, 2015

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 […]
August 19, 2015

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 % […]
August 7, 2015

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 […]
August 5, 2015

News: QlikView Your Business, the Kindle version, is now available!

First of all, my sincere apologies to those who is still waiting for the printed edition of the book. I can’t wait to hold the book in my hands, too, and I totally understand the frustration. The book is in the final stages of production, and will be out very soon. Now, to the good news […]
July 8, 2015

News: Detailed Description of our new book, QlikView Your Business, is now available!

If you’ve been waiting for the release of our new book, QlikView Your Business, then I have good news for you! First of all, I am happy to report that the writing, editing, and correcting is all done. The book is now in production and I don’t expect any more delays. Once the editing work was finished, I […]
June 15, 2015

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. […]
November 28, 2014

News: QlikView Your Business, our new QlikView book, is available for pre-ordering.

  If you are following this blog, you must have noticed that I’ve been very quiet this year. Now is the time to reveal why.  I was writing this book that is almost ready now. The scheduled availability is March 2015. In this book, we tried to bridge the gap between understanding of the business issues at […]
Buy now