Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
adina35
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
carlos_molino
Contributor III
Contributor III

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)