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: 
shoffer
Contributor III
Contributor III

Qliksense Set analysis to ignore current selections not working

So for years, ignoring selections in a chart was easy with Set Analysis,

I could use the following, for example:

 

Sum({<[Selection_Year]=>} SalesValue) 

and whatevery [Selection_Year] was chosen would not affect the chart that has the Set Analysis as shown above.


Now, no matter what I try, I cannot effect this same ability to ignore. What am I missing? We are on latest Qliksense server.

Any ideas?

 

 

 

Labels (2)
4 Replies
ajaykakkar93
Specialist III
Specialist III

hi,

did you try without = 

example 
Sum({<Dim>}Value)

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

Digvijay_Singh

This doesn't make sense, it should work. If you got Avg(Aggr(Sum({<[Selection_Year]=>} SalesValue),dim)) it might not work if outer Avg function doesn't have the same set expression applied.

If you are on Aug 2022, then try this new format, We are still on Nov 2021 so cannot try this new format - 

{<[Selection_Year]=>} Sum(SalesValue) 

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnal...

 

shoffer
Contributor III
Contributor III
Author

YEs...and this did not work either.

shoffer
Contributor III
Contributor III
Author

I am using Cummulative on the lines...maybe if I switch to the Aggr , I will have more luck