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

Sales Contribution accross Dimension Levels

I have a Region Dimension (Region, Subregion, Country) and want to be able to display the % contribution of a Country against the Subregion it belongs to. Likewise, the % contribution of a Subregion against the Region it belongs to.

I tried using the ABOVE and TOP functions, but could not get it to work.

Any help is greatly appreciated.

1 Reply
johnw
Champion III
Champion III

I don't fully understand the question, but something like this?

sum(Contribution)/sum(total <Subregion> Contribution)
sum(Contribution)/sum(total <Region> Contribution)