Need Help Fixing Filter Issue in Qliksense

[natty7]

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!

[Chirantha]

Hey,

Please see if this works.

sum({<OtherDimension1=, OtherDimension2=, ...>} total<Country> TEU)


You can replace OtherDimension1, OtherDimension2, etc. with the names of the dimensions that you want to ignore when calculating the total.