topic Percentage in QlikView

Percentage

upaliwije — Fri, 06 Jun 2014 08:30:56 GMT

=if(I_DAY >= 0 and I_DAY <=15, dual('1-15 Days',1),

if(I_DAY >= 16 and I_DAY <= 25,dual('16-25 Days',2),

if(I_DAY > 25, dual('> 25 Days',3))))

I have above calculated dimension in my pivot table and the resulting out put is as follows

But I want to insert the percentages to this pivot table to look it like as follows

Pls help me to write expression to show the % values

hic — Fri, 06 Jun 2014 08:50:45 GMT

If you perform you calculation in the script:

if(I_DAY >= 0 and I_DAY <=15, dual('1-15 Days',1),

if(I_DAY >= 16 and I_DAY <= 25,dual('16-25 Days',2),

if(I_DAY > 25, dual('> 25 Days',3)))) as DelayClass

then you can calculate the percentages as

Sum(Amount) / Sum(total <Month> Amount)

HIC

hic — Fri, 06 Jun 2014 08:55:51 GMT

In fact, you can do the same also with a calculated dimension... Just create a second expression using

Sum(Amount) / Sum(total <Month> Amount)

HIC

sujeetsingh — Fri, 06 Jun 2014 09:01:48 GMT

You can use another Expression as Labeled '%' and expression as Heneric suggested.

upaliwije — Fri, 06 Jun 2014 09:04:40 GMT

Thanks Henric

But when I add your code to script I get a following message when relaoding

Script Line error

if(I_DAY >= 0 and I_DAY <=15, dual('1-15 Days',1),

Pls help to rectify

hic — Fri, 06 Jun 2014 09:10:31 GMT

Well, you need to give more information than just "Script Line error"... I don't know what your script looks like.

HIC

CELAMBARASAN — Fri, 06 Jun 2014 09:29:25 GMT

You could try Sum(Amount) / Sum(total <Month> Amount) to get percentage.