Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to classify tiers in Qliksense based on a particular program episode and Timeshift?
Here we are calculating the Count(distinct users) for each program episode on a daily basis.
example
Columns:Timeshift 1 2 3 4 5 6 7 8 9 10 11.......16
Measure: Count(distinct users) as Sample
Rows: Program name Air date
Criminal Minds MON-2015-12-21 200 97 94 92 89 84 81 78 76 73 69........
Big Bang Theory MON-2015-12-21 364 192 162 123 121 103 98 93 89 86 81........
In the above example we are trying to compare the Sample based on the timeshift id's '10' to '16'.
In the code the first level of check is timeshift id 10,11,12...16.
a) if the sample is 0 for id '10' then it should be 'Tier 1'
b) if the sample is <> 0 for id '10' then it should be 'Tier 2' and the next id will be picked.
c) if the sample is there for initial 3 id (10,11,12) and not there for 13 then it should be 'Tier 1'
d) Basically for any id(10,11,12,13.....16) selected the code should check the previous id's sample.
Can this be implemented in qliksense