IF(MATCH STATEMENT

[#1]

In Qlik Sense I am trying to use a IF MATCH statement in a filter pane and when I save it, it says OK

Below is an example of the statement.

This is what shows up on the table.

=If(Match(UDRxUnbilled, 'B-1'), 'UDRX Bill Only',

If(Match(UDRxUnbilled, 'BO'), 'RX Bill Only',

If(Match(UDRxUnbilled, 'P-1'), 'UDRX Unbilled',

If(Match(UDRxUnbilled, 'PO'), 'RX Billed',

If(Match(UDRxUnbilled, 'QO'), 'RX Retro Quick',

If(Match(UDRxUnbilled, 'R-1'), 'UDRX Reversal',

If(Match(UDRxUnbilled, 'RO'), 'RX Reversal',

If(Match(UDRxUnbilled, 'UO'), 'UDRX Billed'))))))))

[Chanty4u]

i think there is only values  aviavlbe which reflecting in listbox?  did you checked it?

[Chanty4u]

and check with data once ,here only B-1,P-1,R-1   values only giving.    BO,PO,RO,UO   these are not giving check the data once

[vinieme12 · Accepted solution]

For nested if's use combination of PICK(Match   instead

=PICK(Match(UDRxUnbilled, 'B-1','BO','P-1','PO','QO','R-1','RO','UO')

, 'UDRX Bill Only',

'RX Bill Only',

'UDRX Unbilled',

'RX Billed',

'RX Retro Quick',

'UDRX Reversal',

'RX Reversal',

'UDRX Billed')

or

=AGGR(

PICK(Match(UDRxUnbilled, 'B-1','BO','P-1','PO','QO','R-1','RO','UO')

, 'UDRX Bill Only',

'RX Bill Only',

'UDRX Unbilled',

'RX Billed',

'RX Retro Quick',

'UDRX Reversal',

'RX Reversal',

'UDRX Billed'),UDRxUnbilled)