I can tell you from first-hand experience, getting running counts or balances to calculate accurately in QlikView is not easy. There are data model concerns and then complicated aggregations to deal with. In this post, I will give you a front-end solution “template” for handling running balances in QlikView discussing the nuances with a few use-cases. I will focus on the use of the FirstSortedValue and Aggr functions.
This will work in both QlikView and Qlik Sense. You can download the application I used along with the spreadsheet source here.
Running Balances: Use Cases Full of Nuance
From a front-end perspective, running counts have not generally been a “one size fits all” solution.
Continue reading How To: QlikView Running Counts Using FirstSortedValue at Living Qlik.
Much was made about Qlik Sense when it first arrived on the scene. I found MANY posts about Qlik Sense’s arrival including a post I wrote for LivingQlik over two years ago. Now that the dust has settled, Qlik Sense has been deployed with many of our customers and the product has been through several updates, I have gained a new perspective on the tool.
It is time for another post on the topic because I have come to realize…We have reached the “Tipping Point”. Qlik Sense is now the tool of choice. How do I know this?
Continue reading QlikView vs Qlik Sense: Are We at the Tipping Point? at Living Qlik.
You download your bright, new, shiny QlikView Desktop. You are ready to start on your special BI journey to undiscovered data islands. The excitement is palpable.
Often as a new developer, you don’t know where to start. There is so much to learn. Trying to put the puzzle together in a way that makes sense and is as efficient as possible is not always easy. There is no substitute for a QlikView training course, whether it is on-line or on-site. But to get you started in the right direction, I put together some tips.
Continue reading 19 Tips All QlikView Beginners Must Know at Living Qlik.