Need Help Fixing Filter Issue in Qliksense

adina35 — Thu, 16 Feb 2023 12:40:19 GMT

There is a specific requirement to show the total of a measure , on the basis of a few dimensions and it should not be affected by other dimensions.

I have a table with dimension = ProductName, Country Measure = sum({<ProductName>} total<Country>TEU)

The issue is, whenever I add fields after total i.e. 'Country', the 'ProductName' stops filtering the table.

Please let me know if anyone knows how to make filter work, or an alternate solution to show total. Thanks!

Re: Need Help Fixing Filter Issue in Qliksense

carlos_molino — Sun, 26 Feb 2023 21:50:34 GMT

I don't know if I understood the problem correctly, but try to put the dimensions that you don't want to be filtered in the following way:

sum({<ProductName, Country=,ProductName=>} total<Country>TEU)