Oleg Troyansky
May 9, 2017
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, […]
December 20, 2016
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 […]
October 27, 2016
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 […]
May 16, 2016
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
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
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
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
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
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 […]
December 20, 2016
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 […]
May 16, 2016
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() […]