This content has been marked as final. Show 2 replies
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.