Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
YEs...and this did not work either.
I am using Cummulative on the lines...maybe if I switch to the Aggr , I will have more luck