Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jommy
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
Aditya_Chitale
Specialist
Specialist

Its because you have nullified product name field in your set analysis.

you have written expression to calculate total TEU based on country but then nullified  product name which will  show country wise breakup of TEU values but will make the product name filter inoperative.

You can read more about nullification concept on below post:

Nullification in Set Analysis..?? - Qlik Community - 1100337

Regards,

Aditya