Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple selection in if function

Hello,

I`m using a couple of if functions for setting a selection in a table.

A single if to show just one purchase order state works fine.

Like this =If([PurchaseItemStatus]='2 CONFIRM',[PurchaseItemStatus])

But I can`t make a selection with more purchase order states combined as a selection.

for instance I want all order with state '2 CONFIRM' and '3 QC) in one function

any help would be great

1 Solution

Accepted Solutions
its_anandrjs

Hi,

Use Match function and display the data

=If(Match( [PurchaseItemStatus], '2 CONFIRM' ,  '3 QC' ) ,[PurchaseItemStatus] )

It will match multiple items just put like

'2 CONFIRM' , '3 QC' , etc

Let me know

HTH

Rgds

Anand

View solution in original post

7 Replies
its_anandrjs

Hi,

Use Match function and display the data

=If(Match( [PurchaseItemStatus], '2 CONFIRM' ,  '3 QC' ) ,[PurchaseItemStatus] )

It will match multiple items just put like

'2 CONFIRM' , '3 QC' , etc

Let me know

HTH

Rgds

Anand

swuehl
MVP
MVP

I assume you are looking for OR combination of your states, not AND, since a single record state is bound to a single value, right?

Maybe like:

=If(match([PurchaseItemStatus],'2 CONFIRM','3 QC'),[PurchaseItemStatus])

Regards,

Stefan

Not applicable
Author

Thanks,

that did the trick

its_anandrjs

Hi,

I am also correct would you check it.

Just joking

Rgds

Anand

Not applicable
Author

Both are Correct!!

its_anandrjs

Hi,

Yes Both are correct and we are glad to help you we try to do as soon as possible.

Rgds

Anand

Not applicable
Author

Hi,

one question more regarding this selection.

How do you select , without any status, so status is not filled in

And how do you select, with if filled in (with any data) then select