Discussion board where members can get started with Qlik Sense.
In case1 we are filtering for DVR, that is if the condition fails in the first step it will come out of the loop and display some other than DVR.
if(INDICATOR_ID> 9 ,
'DVR After 7 Days','DVR Till 7 Days'),VIDEO_TYPE) as VIDEO_PLATFORM
I have to achieve the same functionality as above with meeting the criteria below. Can anybody help me with this
IF ((VIDEO_TYPE='DVR' AND TIMESHIFT_ID> 9) ,'DVR After 7 Days',
IF((VIDEO_TYPE='DVR' AND NOT TIMESHIFT_ID> 9), 'DVR Till 7 Days',
IF((VIDEO_TYPE='OTT/VOD' AND TIMESHIFT_ID> 5 AND STREAM_SOURCE='VOD') ,'VOD Till 3 Days',
IF((VIDEO_TYPE='OTT/VOD' AND STREAM_SOURCE='VOD'), 'VOD After 3 Days',
IF((VIDEO_TYPE='OTT/VOD' AND NOT STREAM_SOURCE='VOD'), 'OTT',
VIDEO_TYPE))))) AS VIDEO_PLATFORM_VOD
I am not an expert by any means - but this linked helped me:
A little tool for creating nested if-statements