Classification of Tiers based on program episodes and timeshift id's

[#1]

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.

[#2]

Can this be implemented in qliksense