QlikView Set Analysis – A Scary Subject
Set Analysis is a scary subject. I would surely claim it is the most difficult part of developing your QlikView front-end.
I have waited to throw my hat in the ring regarding set analysis. This is mostly because I didn’t feel I had much to add, but also because Set Analysis in QlikView is a formidable subject.
But the time has come for LivingQlik to cover Set Analysis. Firstly, no self-respecting blog would be complete without tackling the subject. Secondly, I feel that there is room for a compete reference presented in a clear voice.
Continue reading LivingQlik Roots: The Ultimate QlikView Set Analysis Reference at Living Qlik.
I am a QlikView Ninja!
QlikView Ninjas can quickly slice and dice QVDs with exacting precision. How do I do this with the skill of a Ninja?
Well, I use my Ninja Sword of course! In this case, my blade of choice is a finely crafted weapon forged from the hands of the developers at EasyQlik. This weapon is called QViewer. In today’s post, we will go through some great use-cases for QViewer.
What is QViewer?
QViewer is developed by Dmitry Gudkov, a friend of LivingQlik, a blogger in his own right over at BI Review, and a developer of tools like QViewer and EasyMorph.
Continue reading QViewer: A Powerful, Light and Fast QVD Viewer for QlikView Ninjas at Living Qlik.
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.