Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fortaleza40
Contributor III
Contributor III

Unified number format

I have a field with a numeric value, i need to format it, but the user input different values (same field is used for multiple purpose), so i can have age data, 8, money data, 1.000.000, lead zeros, 012345, and others, all numeric, so i am trying to do a unified number format but doesn't work, some of the format broken or remove lead zeros, so i need your help, this is what i am doing:

Num(Alt([My Value],
            Num#([My Value], '#####'),
            Num#([My Value], '## ##0'),
            Num#([My Value], '####0'),
            Num#([My Value], '00000'),
            Num#([My Value], '00.000')
            ))
0 Replies