3 Replies Latest reply: Jul 15, 2017 6:55 AM by Vineeth Pujari RSS

    IF(MATCH STATEMENT

    Robert Winkel

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