topic value as a % in pivot table in QlikView

value as a % in pivot table

Thu, 16 Feb 2012 13:53:26 GMT

hi friends,

how to format the value to show as a % in pivot table

forex:

revenue=600

ebit=500

%=500/600*100

i written expression like this to show %, by clicking number tab->fixed to>show in percentage

but its displaying like 1223.344%

Q.how can i achie % format manually in pivot table expression

CELAMBARASAN — Thu, 16 Feb 2012 13:58:28 GMT

Hi,

No need to multiply with 100 if you check the show in percentage option.

Just use %=500/600 i.e ebit/revenue

Celambarasan

jagan — Thu, 16 Feb 2012 14:00:15 GMT

Hi,

There is no need of multiplying with 100, when you select percentage it automatically does this.

Hope this helps you.

Regards,

Jagan.