Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum over hierarchical dimensions

Hi all,


I have a challange for you.           I have a market dataset with different brands and each brands has different products. Some products are ours, other are not. There is a brand that has two products of my company.

I would like a pivot table with products (and brands if needed) as dimension and the sum of volume for each brand as expression; I also would like it dispite selections on brands or products..

Please see the excel attached for details.

BTW I simplified it a bit, just consider I also have to use set Analysis in the sum (like {$<MeasureType={'ITM'}, DYear={$(CurrY)},...).

Thank you very much!
Alessandro

0 Replies