title: Qlikview Report for one Category with Charts that Contain Other Metrics
body: <p>I am trying to create a report that all updates according to one location out of 35. In essence, I have 35 locations and so I will filter on one of the locations to update the whole report with data that relates to that location. However, there are charts I want to create that should be summed for the whole country, but I am having a hard time creating charts with all 35 dimensions because I don't want to unclick my filter.</p>
  
  <p>For example, I want one table that has all 35 locations and their respective categories (e.g., total score, total employer score, etc), but I can only achieve this table if I do not click on any of the locations in the "locations" field.</p>
  
  <p>Is there an expression I need to specify for the dimension "locations" that will show all dimensions, even if I have one of them selected for the rest of the report?</p>