If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a requirement with two conditions
1) If(DSI<14 and open orders=0 and match(report metric key,5),1,0)
2) if(open orders=0 and match(report metric key,1,2,3,4,5,6,7),1,0)
How can I combine these two if condition in data load editor and create a flag ??
Thank you Vineeth. Second expression looks fine. I see four dummy values 99991,99992,99993 and 99994 in DSI after using your second expression. How can I remove these values from the same expression?
Also I can see both <14 DSI and > 14 DSI values for report metric key 5 after using your expression. How can we fix it
That is because of your second condition you want all report metrics keys from 1 to 7
Can you confirm exactly what you need?
If the DSI < 14 is only applicable to metric 5, then remove 5 from the 2nd condition
if(open orders=0 , if( (DSI<14 and match(report metric key,5)) OR (match(report metric key,1,2,3,4,6,7)),1,0),0) as FLAG
I kept report metric key only 2 in second expression. Also removed 1 and 4 from first condition.
Still in table I see values >14 and <14 for DSI.
if(Open orders=0 , if( (DSI<14 and match(report metric key,5))
OR (match(report metric key,2)),1,0),0) as DSI_Open_Orders,