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:

       

      PRODUCT    VALUE      ACCOUNT

      ----------------------------------------------------------

      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.

       

      Thanks,

      Tim