topic Re: pivot table error with percentage. in QlikView

pivot table error with percentage.

Anonymous — Mon, 23 Nov 2015 07:55:42 GMT

I faced a problem when I change the format of number like the following picture

I need to view the number as 2.3 %, 4.7% for example.

not 232% or 475%

Regards,

marcus_sommer — Mon, 23 Nov 2015 08:01:57 GMT

It depends how you calculate and/or display your results - in your case you need only to divide your result through 100.

- Marcus

arasantorule — Mon, 23 Nov 2015 08:08:01 GMT

Hi,

Please can you check your expression for "unit Cost".

I think the expression you are using may be (A/B)*100 instead of (A/B).

Please let us know if otherwise.

Thanks.

vikasmahajan — Mon, 23 Nov 2015 08:17:09 GMT

right click chart -> select number ->select show in Percent(%) option and check.

HTH

Vikas

Chanty4u — Mon, 23 Nov 2015 08:23:50 GMT

use the formula /100 or u can try or go to number tab and select number and show in % .. u wil get the exact value

hope this helps u

Thanks

Suresh

jagan — Mon, 23 Nov 2015 08:24:35 GMT

HI,

Divide your expression by hundred so that you will get the required result.

Regards,

Jagan.