Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sirpod90
Contributor III
Contributor III

Conditional Filter for Expression in Qlik Sense

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


1 Reply
sirpod90
Contributor III
Contributor III
Author

Is there really no workaround possible yet?