Posts

"How do we get people to stop using Excel?"

From Pretend Store Perspective A customer recently asked us the title of this post, but before we get there, a question you should fir...

Median >>> Average, usually

From analytics curmudgeon Stephen Few's The Data Loom : Weaving Understanding by Thinking Critically and Scientifically with Data , ...

Does the order of fields affect Qlik aggregation/GROUP BY performance?

The short answer is: not really. It's not an interesting conclusion, but I am documenting the negative result here in case somebody i...

Please use this instead of Always One Selected or Pick/Match

Use case Developers often want one input to control many properties in an application: metrics or dimensions in a chart, labels, titles...

Presentation: Reviews are good, standards are better

Here is a recording of the presentation I gave to the Atlanta Qlik Dev Group last spring. Thanks to Shilpan and Claudia for inviting me! ...

Tuning a Qlik application: back end

from Ptarmigan Labs   Tuning a large, complex Qlik application can be an intimidating prospect. How do you add order to the madness...

Star schema dimensions: to join or not to join? redux

I did further testing of scenarios from this previous post comparing joining dimensions to sorting by key fields: in Qlik Sense using th...

How to think like an analytics architect 🧠

Assume that everything you do will be wildly successful. As a result of this inevitable success: You will have to explain the process to ...

Why is the combined size of partitioned QVDs smaller on disk than just creating one QVD?

Note in this screenshot that the first QVD is larger than combining ten equal row count slices of it, stored to QVDs. A customer recently no...

Contact Form

Name

Email *

Message *