IF statement two or more selections in same field

[Anonymous]

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!

[sunny_talwar · Accepted solution]

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

[Anonymous]

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.