Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

IF(MATCH STATEMENT

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'))))))))

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: IF(MATCH STATEMENT

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)

3 Replies
Highlighted
sureshqv
Esteemed Contributor III

Re: IF(MATCH STATEMENT

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

sureshqv
Esteemed Contributor III

Re: IF(MATCH STATEMENT

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
Esteemed Contributor II

Re: IF(MATCH STATEMENT

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)

Community Browser