6 Replies Latest reply: Apr 16, 2018 3:36 AM by Petter Skjolden RSS

    Substring - Set Analysis

    Tim Müller

      Hi Folks,


      how it is possible to define a substring in an expression?


      My data spitting out two values from each of my 1000 products and qlik sum up this two values. Simplified a double date input in Qlik. For example:




      BASIC          1000           A100

                           1000           A100_X



      Each Product has two ACCOUNT numbers. I want to select only Values without the Suffix _X.


      That implies a value of 1000 for my product BASIC and not 2000.

      Please can you help me with my set analysis.