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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis full set {1} problem

Hi, I am trying to make the expression below return the full data set. I have put the set identifier {1} in all of the places it might need to be on aggregation functions. However in the app it still only brings back the current selections. I think that it must be because of the fields the aggr functions is working on, especially [Unique ID] but I dont know how to fix it. Any ideas please? max({1} aggr(sum({1}aggr([Savings]*((round(avg({1} [Question Response]))-1)/4),[Question Number], [Unique ID])),[Unique ID]))

11 Replies
Not applicable
Author

Thanks to all of you who helped on this

Not applicable
Author

I put this back in the scatter chart and it turned out that the problem all along had been that I had not put any set analysis on the other dimension