topic Re: Total percentage calculation in QlikView

Total percentage calculation

Wed, 10 Apr 2013 21:58:57 GMT

Hi I am trying to calculate the total percentage in this qva, any help would be appreciated.

I have attached the file.

Re: Total percentage calculation

CELAMBARASAN — Wed, 10 Apr 2013 22:49:35 GMT

Use sum of rows option. by defaul it will be sum of expression.

Re: Total percentage calculation

Thu, 11 Apr 2013 07:51:50 GMT

ctheresa75

maybe you can help this to you

if(Dimensionality()=0,

sum(aggr([Monthly Goal]/sum(Total [Your Expression in Monthly Goal]),Dimensions)),

[Monthly Goal]/sum(Total [Your Expression in Monthly Goal]))

regard

GERNAN

Re: Total percentage calculation

narender123 — Thu, 11 Apr 2013 10:50:09 GMT

Select Chart Property->expression->Select Sum of rows button .

Try it.

Regards:

Narender

Re: Total percentage calculation

Thu, 11 Apr 2013 12:14:49 GMT

Sum of option works for the other columns , see the total in the snap shot but not in the ‘Goal %”

Re: Total percentage calculation

Thu, 11 Apr 2013 16:28:24 GMT

Thanks for getting back to this, well I try sum of row button, it gives the answer as 165% which Is wrong, supposed to be 20%.

Re: Total percentage calculation

Fri, 12 Apr 2013 04:20:15 GMT

ctheresa75

what is your expression in 'GOAL %' ?

please give to me

Re: Total percentage calculation

Fri, 12 Apr 2013 04:38:43 GMT

ctheresa75

i think like this ?

if(Dimensionality()=0,

sum(Total [Total Billed GP])/sum(Total [Your Expression in Monthly Goal]),

[Total Billed GP]/sum([Your Expression in Monthly Goal]))

regard

GERNAN

Re: Total percentage calculation

preminqlik — Fri, 12 Apr 2013 09:20:28 GMT

send your field name expression once ?...i mean GOAL % expression?

Re: Total percentage calculation

Fri, 12 Apr 2013 12:37:19 GMT

Thanks I will try this and will respond.

Re: Total percentage calculation

Fri, 12 Apr 2013 13:46:25 GMT

Hi, here is the Goal % expression. Just to note, I tried expression total for the Goal % column and it doesn’t work.