topic Re: Dynamic number formatting from number in QlikView

Dynamic number formatting from number

koushik_btech20 — Thu, 16 Mar 2017 09:37:48 GMT

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

Re: Dynamic number formatting from number

migueldelval — Thu, 16 Mar 2017 09:44:07 GMT

Hi Koushik,

Try this example please.

Regards

Miguel del Valle

Re: Dynamic number formatting from number

koushik_btech20 — Thu, 16 Mar 2017 09:50:02 GMT

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