1 Reply Latest reply: Feb 4, 2016 3:24 AM by Ravikiran Pat RSS

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

    Ravikiran Pat

      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.

       

      cap2.JPG