2 Replies Latest reply: Sep 27, 2011 10:33 AM by d.n.a.1987 RSS

    Total for a dimension with multiple selection

      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.