Qlik Aggregation issue

Fareeha123 — Thu, 05 Dec 2024 17:37:09 GMT

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)),

$(vCountryAggr)

)

Re: Qlik Aggregation issue

QFabian — Thu, 05 Dec 2024 18:46:18 GMT

maybe with some example data we can help more

topic Qlik Aggregation issue in App Development

Qlik Aggregation issue

Re: Qlik Aggregation issue