Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ShellyG
Creator
Creator

Pivot Table data doesn't stack up to 100%

Dear all, 

I have an issue with a pivot table I created. I am using the following fields:
Rows - Country (the field only contains country names)
Column - Year (only years)

Measure - (sum({<Year = {'$(=max( {<Source={'Main'}>}Year))'}>}aggr(sum(Units), Year, Country))+sum(aggr(sum(ForecastUnits),Year, Country)))
/$(=sum({<Year = {'$(=max( {<Source={'Main'}>}Year))'}>}aggr(sum(Units), Year, Country)))

The results I get in the table are correct only when I select a specific country. The only problem is that Qlik Sense splits all the countries and the total of the countries is 100%. Instead I would like each country to be separately for itself 100%. 

Any ideas on how to edit the expression? 

Labels (2)
0 Replies