Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))))))))
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)
i think there is only values aviavlbe which reflecting in listbox? did you checked it?
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
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)