Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Conditional Filter for Expression in Qlik Sense


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

1 Reply
New Contributor III

Re: Conditional Filter for Expression in Qlik Sense

Is there really no workaround possible yet?

Community Browser