LivingQlik Roots: The Ultimate QlikView Set Analysis Reference

LivingQlik Roots: The Ultimate QlikView Set Analysis Reference

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.

Continue reading

QViewer: A Powerful, Light and Fast QVD Viewer for QlikView Ninjas

QViewer: A Powerful, Light and Fast QVD Viewer for QlikView Ninjas

 

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.

Continue reading

How To: QlikView Running Counts Using FirstSortedValue

How To: QlikView Running Counts Using FirstSortedValue

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.

Continue reading