We have created a dimension to show top 5 countries. A measure where we are calculating the percentage share for the countries. Business wanted to see always share to sum upto 100%. we are aggregating the measure for the dimension then taking the max share and then adding and subtracting from it to make the sum of all shares equal 100%. This has resolved our issue. This aggregation has caused another issue that it is showing countries on the graph with 0% value that are not for that client filter. We are filtering the dashboard for a client, date range. Can you tell why Qlik in showing the countries after aggregation that are not part of that client filter on the graph ?. We can see e.g. Hong Kong for month of Nov 24 but Hong Kong is not available for Client ABC in data but it is showing on graph with 0% value. Why is qlik doing that.
Mesaure Formula:
if ($(vCountryAggr)= $(vMaxCountryShare) and RowNo() = 1, ($(vMaxCountryShare)-round(TotalValueCountry-1,0.001)),
