topic Percent of Total Dimension in QlikView

Percent of Total Dimension

simonagheo — Sat, 16 Nov 2024 00:16:16 GMT

Hello,

I have a pivot table (the first one) with the following dimensions: Location, Dimension and Line and three expressions:

1. The Total Amount by dimensions

2. %: the percent between each line and the R line.

3. AVG %: the percent between each line and the R line but without location selected.

I made the first and the second expressions.

One problem is that the second expression isn't calculated at the Total, and the biggest problem is that I can't make the third expression to ignore the location. The AVG % should be exactly like the AVG % from the second table, no matter what location is in the first table.

I attached my qvw file.

Can you help me?

Thank you!

Re: Percent of Total Dimension

rubenmarin — Sat, 25 Jul 2020 09:46:34 GMT

Hi, for 2nd expession you can use:

=sum(Amount)
/sum(TOTAL <Dimension,Location> {<Line={"R1","R2"}>} Amount)

And for the 3rd:

=sum(TOTAL <Dimension, Line> Amount)
/sum(TOTAL <Dimension> {<Line={"R1","R2"}>} Amount)

Re: Percent of Total Dimension

simonagheo — Sat, 25 Jul 2020 20:58:22 GMT

It's working. Thank you!