Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need to load "material number" from original file as:
I want to have results shown as:
Actually, to eliminate the possible zeros at the beginning. The zero appears if there is only figures.
How shall I script???
Maybe this (I found this here How to remove the leading zero's in the alphanumeric field values)
mid([YourField],index([YourField],left(PurgeChar([YourField] , '0' ),1)))
I hope it helps!