1 Reply Latest reply: Nov 21, 2016 3:52 AM by Tobias Stolpe RSS

    Conditional Filter for Expression in Qlik Sense

    Tobias Stolpe

      Hello,

      I am trying to improve the user handling and experience.

       

      In a table I show some values: for example material number and measurement

      The material number has leading zeros and trim them for a better overview.

       

      replace(ltrim(replace([MATERIAL],'0',' ')),' ','0')

       

      When I now click on one material number my filter looks like that:

      =Replace(LTrim(Replace([MATERIAL],'0',' ')),' ','0') = XXXX

       

      How can I set the filter to the original number and not the expression i defined?

       

      So i want the filter to be set to:

      MATERIAL = XXXX


      Are there any conclusion in Qlik Sense to do it or it is only possible in QlikView?


      Thanks and regards