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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator

Dynamic number formatting from number

Hi All,

I want to format number from a variable where in the variable user can input one number say 1 or 2 , so now if they input 1 then we have to show 1 decimal places and for 2 we have to show 2 decimal places.I want to do that in for loop inside the load script. There will be a initial value for 0 decimal i.e. '#,##0'. I did based on the attached application. But I want a better approach.

Kindly check the attached app and  help me to achieve this through for loop.

Regards,

Koushik

2 Replies
migueldelval
Specialist
Specialist

Hi Koushik,

Try this example please.

Regards

Miguel del Valle

koushik_btech20
Creator
Creator
Author

Hi Miguel,

Thanks for the quick reply. But I want dynamic formatting through loop not using if condition. Even when I did a entry of 0 for vSignificnatDecimal your expression is not working.

Thanks,

Koushik