topic multiple selection in if function in QlikView

multiple selection in if function

Fri, 30 Sep 2011 14:03:37 GMT

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

Re: multiple selection in if function

its_anandrjs — Fri, 30 Sep 2011 14:06:50 GMT

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

multiple selection in if function

swuehl — Fri, 30 Sep 2011 14:06:58 GMT

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

multiple selection in if function

Fri, 30 Sep 2011 14:11:42 GMT

Thanks,

that did the trick

Re: multiple selection in if function

its_anandrjs — Fri, 30 Sep 2011 14:13:30 GMT

Hi,

I am also correct would you check it.

Just joking

Rgds

Anand

multiple selection in if function

Fri, 30 Sep 2011 14:17:21 GMT

Both are Correct!!

multiple selection in if function

its_anandrjs — Fri, 30 Sep 2011 14:19:01 GMT

Hi,

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

Rgds

Anand

multiple selection in if function

Wed, 05 Oct 2011 07:22:34 GMT

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