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