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

    Conditional Filter for Expression in Qlik Sense

    Tobias Stolpe


      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:


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

      Thanks and regards