4 Replies Latest reply: Oct 30, 2015 9:44 PM by Jeff Menzie RSS

    If a value ends with a certain two figures

      Hi,

       

      I am new to Qlikview. I have a list or order numbers. The orders that end in an 81 are those that belong to a specific product type (type a)

       

      45615

      123

      7894

      581

      44781

      75984

      4581

       

      I would like to use an IF function to return those order numbers that end in 81 to be highlighted as 'type a' and the others as 'type b'.

       

      Can you help please?

      Thanks