topic Re: IF statement two or more selections in same field in QlikView

IF statement two or more selections in same field

Anonymous — Fri, 09 Oct 2015 19:32:19 GMT

Hello Community,

I am new to QlikView. How do you add a condition for two selections in an if statement. For example, I have a list box called App_Status that includes

Passed

Waiting

Failed

I want to have a condition in a text box that displays a message if Waiting and Failed are both selected. I tried this but had no luck:

if(App_Status= 'Waiting' AND App_Status = 'Failed', 'Waiting and Failed Applications')

Thanks in advanced!

Re: IF statement two or more selections in same field

sunny_talwar — Fri, 09 Oct 2015 20:42:15 GMT

May be try this:

=If(GetFieldSelections(App_Status) = 'Failed, Waiting', 'Waiting and Failed Applications)

Just make sure to put the same thing within the single quotes (Failed, Waiting) which you see when you put GetFieldSelections(App_Status) in a text box (exact same spaces and upper/lower cases) when you select Failed and Waiting in App_Status list box.

HTH

Best,

Sunny

Re: IF statement two or more selections in same field

Anonymous — Mon, 12 Oct 2015 13:34:23 GMT

Thanks! Tried it and it worked. Just to note, the order matters. I originally did 'Waiting, Failed' and it did not work, so i tried 'Failed, Waiting' and it worked.