Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summarization of a higher dimension in a Pivot Table with calculated dimensions and without using AGGR

Hello experts!


I have a simple question...


In a Pivot Table I have Dimensions and Calculated Dimensions:

22-06-2015 05-47-01 p- m-.png


Yellow: Dimensions.

White: Calculated Dimensions.

Green: Expression.


The calculated dimension is the sum of the previous dimension:


DC GRUPO SUB CANAL:

AGGR(SUM(Units), CANAL, GRUPO SUB CANAL)



I need an expression that makes the sum of Units of previous dimension, in this case the sum of Units grouped by GRUPO SUB CANAL. It is possible to make a expression of previous dimension in a Pivot Table with dimensions calculated without using AGGR? Something like that: SUM(TOTAL<Dimensións, Calculated Dimensions>Units)


Thanks a lot!!!

Regards,

Juan Pablo Rodrigues.


0 Replies