6 Replies Latest reply: Sep 19, 2015 3:30 AM by Sunny Talwar RSS

    How to write nested if conditions or case statements to suit the following requirement

    Ravikiran Pat

      Hi All,

       

      Please help me with the code given below.

       

      IF(VIDEO_TYPE='DVR',

             IF(TIMESHIFT_ID> 9,'DVR After 7 Days','DVR Till 7 Days'),

                  IF(VIDEO_TYPE='OTT/VOD',

                       IF(STREAMING_SOURCE='VOD',

                            IF((TIMESHIFT_ID> 5,'VOD Till 3 Days','VOD After 3 Days'),'OTT',

      VIDEO_TYPE)))) AS VIDEO_PLATFORM_W_VOD,

       

      There is something wrong in this code, iam using this in the load statement in qliksense to get the dimension for a specific use.

      The purpose of this is to include DVR as a first condition and in the inner loop TIMESHIFT_ID>9 if success display1 or display2

       

      First condition checks for DVR, 3rd again checks for VIDEO_TYPE = OTT/VOD. The above statement is giving an error while loading the data in qliksense. Please help me its urgent

       

      Thanks

      P.Ravikiran

      09590574999