Wednesday, 9 July 2014

Set analysis that ignores all selections except a few

›
How do you get Set Analysis to ignore all selections except for a few fields? We have a calendar table, linked to a fact table and some se...
8 comments:
Wednesday, 5 February 2014

Moving average chart.... QlikCommunity discussion

›
Following on from my post on six sigma charts here , a discussion has opened up on QlikCommunity on moving the average once the n-points rul...
1 comment:
Wednesday, 2 October 2013

Confidence intervals and funnel plots: please read this first! #1

›
At work, people are using more and more confidence intervals or funnel plots in their data as part of their decision making processes. Wh...

How to reload on top of your existing data in your dashboard (bit of a cheat)

›
Did you know you can use a simple statement to load data back in from your own application? This is handy if you need to tweak data and avo...
Saturday, 14 September 2013

How to create 4,294,967,296 rows of data from 1 duplicate in 5 easy moves

›
Like this: You load data from a source with an allegedly unique key. Then you need to do some calculations on it, using data from other...
Sunday, 24 March 2013

Qlikview Lean tips #1: How to highlight series of points that violate control rules on a chart

›
Highlighting patterns of points on a chart Control charts are charts that plot some sort of quality measurement, for example number...
24 comments:
Friday, 8 March 2013

Hierarchical sheets navigation in QlikView ("breadcrumbs")

›
Ever wondered how you can get website style navigation in QlikView? By that I mean you start with a home page, and a menu, and as you whit...
4 comments: