Need Help Fixing Filter Issue in Qliksense

[kritiment]

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!

[neerajthakur]

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

Write this expression as  sum({<ProductName={''},Country={''}>} total TEU)

You can specify ProductName and Country in single quotes and for more than one value use comma like this 'India','Egypt','US'

[BenjaminT]

If I've understood correctly, all the rows in the table will display even when you filter to a ProductName, because the set analysis of your measure is ignoring selections on ProductName. One way to work around this is to add the measure column as a dimension column as follows:

aggr(sum({<ProductName>} TEU), Country)

Hope this helps