topic Total for a dimension with multiple selection in QlikView

Total for a dimension with multiple selection

Tue, 27 Sep 2011 13:57:30 GMT

Hi,

I'm relatively new to Qlikview and having a bit of an issue calculating a total.

What I am trying to is calculate the total sales of all departments within a business to use to calculate the percentage that each department within the business is using. Using the total command this works to an extent however the document I am creating compares multiple businesses. When multiple businesses are selected the total commands gets the total for all the businesses selected when I need it to calculate this for each business seperately.

I can't simply place the name of the business to be checked into the expression as this expression needs to work with all possible businesses that could be selected.

Total for a dimension with multiple selection

sridhar240784 — Tue, 27 Sep 2011 14:28:53 GMT

Are you looking for something like this?

Sum(Sales) / Sum(Total<BusinessUnit> Sales)

If this doesnt help you, Please post sample of your data and explain us your requirement.

-Sridhar

Total for a dimension with multiple selection

Tue, 27 Sep 2011 14:33:09 GMT

Thanks, that works.

I was sure the functionality was there and knew what I needed to do but had no idea how to structure the expression to do it.