topic Re: Calculated Dimension for Pivot Table in QlikView

Calculated Dimension for Pivot Table

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I want to to create a table like the one shown in the image below.

I have the following dimensions:

Day

Week

BultoStock

KiloStock

Any idea how to do this?

I think this can be done with calculated dimension, but cannot make it work!

sunny_talwar — Tue, 29 Nov 2016 20:30:54 GMT

Would you be able to share some sample raw data and explain the expected output?

rupamjyotidas — Tue, 29 Nov 2016 20:32:24 GMT

In Dimension for sum()

=aggr(sum(BultoStock),Especie)

=aggr(sum(KiloStock),Especie)

Also you need the following dimension

Especie

day/week

Expression :

Sum(BultoStock)

Thanks

cristian_av — Tue, 29 Nov 2016 21:03:56 GMT

Thanks!

It works, but I can't show the Totals for the grouped dimensions. Any idea about how to do it?

If I use the "Show partial Sums", I get the following:

I've tried drag&drop but cannot make it work!

rupamjyotidas — Tue, 29 Nov 2016 21:06:53 GMT

Totals for the group dimension won't be possible, as Totals works only for Expressions.

cristian_av — Wed, 30 Nov 2016 19:09:36 GMT

I Solved it by putting another pivot table over the principal one.

Then I've hide the borders, change the background color.. and nobody will notice it hehe

rupamjyotidas — Wed, 30 Nov 2016 19:12:31 GMT

. Problem might come when users does selections. So test and Test:)