Today, I will cover some basics on how to create dimension groups for your QlikView applications. I will also talk about using GetCurrentField to make your charts behave more seamlessly with your groups. This info is must-have for any serious QlikView developer.
What are Grouped Dimensions?
When you build a chart, you typically will use at least one dimension field so that the aggregation in your expression gets calculated for each value in your dimension list. This is a simple concept that we can expand on.
Grouped Dimensions allow the user to “switch out” the dimension with another field.
Continue reading LivingQlik Roots: How-To Create Cyclic and Drill-Down Grouped Dimensions at Living Qlik.
Every year, the worst movies of the year coming out of Hollywood are “honored” with an award called the Razzie. In an industry that normally pats itself on the back at every turn, the Razzies are a nice way to recognize that not every film churned out of the Hollywood machine is worthy of praise.
In similar fashion, I thought it would be fun to award some of the worst data visualizations coming out of our collective BI industry. Although it is always fun to poke fun at data visualizations that might be lacking in usefulness, it is also an opportunity for us to learn so that we do not make the same mistakes in our own work.
Continue reading The 9 Worst Data Visualizations Ever Created at Living Qlik.
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.