Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
maynovent
Contributor
Contributor

Need Help Fixing Filter Issue in Qliksense

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!

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Hi, By default, all dimension values are disregarded by the total qualifier. And so, the dimensions needed to interact with chart expressions must be specified.

=Sum(TOTAL <ProductName, ... > TEU)