Conditional Filter for Expression in Qlik Sense

sirpod90 — Fri, 18 Nov 2016 10:37:59 GMT

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

Re: Conditional Filter for Expression in Qlik Sense

sirpod90 — Mon, 21 Nov 2016 08:52:36 GMT

Is there really no workaround possible yet?