Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
MVP
MVP

Sales Contribution accross Dimension Levels

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

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

Community Browser