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 selections are made.

We now want to work out a calculation based on the date range selected (eg WTE) - but there is a problem. As the data is linked, our non-calendar selections (in this case employee) are only linked to some of the dates - infact for 2014 only in the month of May!

So any calculations based on number of days, etc will only return what is in the data. Furthermore, using the {1} set analysis to ignore all selections will ignore also the selection in year, but we need that. And what if you have hundreds of fields to list?

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 rule has been violated.

The problem is that the calculation for the average is iterative- once you work out a new average, the test for the points moves. This makes it tricky to achieve in the application, although it can be done in the script.

Any ideas anyone?