Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have a chart that uses the dimension Region(Region_RE). When a user selects a region, I would like the chart to filter accordingly but additionally display the regranting emissions associated with the region as defined by the field GCAM Region. I have tried a number of different configurations of the set analysis, but have not been successful.
=Count({< Region_RE=, [GCAM Region] = p({<Region_RE+={'Remaining Emissions'}>} [GCAM Region])>}Distinct Region_RE)
My goal here was to ignore the selection of the Region_Re while selecting the same value in the field GCAM Region, but when a Region is selected, nothing is filtered.
Please let me know if you can help!
Thanks!
Perhaps this?
=Count({<Region_RE={="Only{{<Region_RE>} Region_RE)=Only{{<Region_RE>} [GCAM Region])"}>} Distinct Region_RE)
Thanks for the quick response- I had to make a couple of tweaks to get the expression to display, and I found a couple of issues with the output. Regranting Emissions is no longer displaying, and the region does not react to filtering- output below.
=Count({<Region_RE={"=Only({<Region_RE>} [Region_RE])=Only({<Region_RE>} [GCAM Region])"}>} Distinct Region_RE)