Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tschullo
Creator III
Creator III

Set Analysis forces chart to display data disregarding filters

I have run across this issue before:

I have a chart that shows data for restricted by set analysis in the expression definition, for example:

Sum({<Category={"A","B"}>} Sales)

If a user then uses a filter to attempt to only display Category A, the chart ignores the filter.

My solution has always been to add a new field in script that captures those two categories as one, for example CatAB='Y'.
I can then modify the expression to Sum({<CatAB={"Y"}>} Sales) and now it respects the user filtering by Category.

Is there no other simpler way to handle this?  I'm still not clear on why set analysis behaves this way.  Seems a bit overbearing.

Labels (2)
1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Add a star before the = sign

Sum({<Category*={"A","B"}>} Sales) 

View solution in original post

3 Replies
Digvijay_Singh

not sure but try this may be - 

Sum({<Category={'A','B'}>*<Category=P(Category)>} Sales)

Clever_Anjos
Employee
Employee

Add a star before the = sign

Sum({<Category*={"A","B"}>} Sales) 

tschullo
Creator III
Creator III
Author

Thanks!