topic Re: Number formatting in % in QlikView

Number formatting in %

Tue, 04 Jun 2013 04:13:16 GMT

I am displaying a text object as follows

=Num(((Sum(Online_Sales)/(Sum(Online_Sales)+ Sum(Retail_Sales)))*100),#,##0.00%)

If I manually calculate the values should be in Single digit. approx 2.41%. I am getting 241.48%.

Should I multiply by 100 ?

vikasmahajan — Tue, 04 Jun 2013 04:18:54 GMT

Select number tab fix 2 decimal and multiply formula by *100 and select Show in % setting

Hope this will resolve your problem

Vikas

Sokkorn — Tue, 04 Jun 2013 04:38:21 GMT

Hi sairan06,

=Num(0.0241,'#,##0.00%') Return 2.41%

Apply to your expression, we should not multiply by 100.

Regards,

Sokkorn

er_mohit — Tue, 04 Jun 2013 05:18:26 GMT

Try this

Num((Sum(Online_Sales)/(Sum(Online_Sales)+ Sum(Retail_Sales))),#,##0.00%)