topic Percentage calculation on dimension subtotal in QlikView

Percentage calculation on dimension subtotal

Fri, 29 Jan 2010 17:35:55 GMT

Hello experts,

I have this scenario:

In a pivot table with 2 dimensions ("line" and "sector") and the following definition as expression:

=Sum(ImportoOrdinatoRiga) / sum(total ImportoOrdinatoRiga)

the above expression give me the percentage on "line" dimension total (grand total), while I need the percentage on the "sector" dimension total.

How can i achieve it?

thanks in advance.

Best regards

Andrea

Fri, 29 Jan 2010 17:37:24 GMT

Try:

=Sum(ImportoOrdinatoRiga) / sum(total <sector> ImportoOrdinatoRiga)

That should give you the percentage of the sector. The denominator will be the sector total.

Fri, 29 Jan 2010 17:48:29 GMT

i tried it but the results is the same!

Fri, 29 Jan 2010 18:16:54 GMT

The same? That seems odd. What order are your dimensions in?

I actually think you'll need to use:

=Sum(ImportoOrdinatoRiga) / sum(total <line,sector> ImportoOrdinatoRiga)

But the original expression shouldn't have given you the same value as your expression. Try it with just the total sum as an expression.

Sun, 31 Jan 2010 04:26:35 GMT

Please use this

=Sum(ImportoOrdinatoRiga) / sum(total <line> ImportoOrdinatoRiga)

Anonymous — Mon, 11 Jun 2012 18:28:21 GMT

Can we use the same concept in a bar chart?