IF condition script

[Anonymous]

Hi Qlikview experts, how can I use If condition in the script when I have the situation below?

Load,

if ((qty(flag='a' and is not null) > qty(flag='b' and is not null)),qty(flag='a'),qty(flag='b')) as NewQty

Best Regards,

[sunny_talwar]

Would you be able to show 5-10 rows of data to show your data to see what you might have?

[saimahasan]

Please elaborate your requirement.