This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
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
View solution in original post
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?
=If(match([PurchaseItemStatus],'2 CONFIRM','3 QC'),[PurchaseItemStatus])
that did the trick
I am also correct would you check it.
Both are Correct!!
Yes Both are correct and we are glad to help you we try to do as soon as possible.
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