Set analysis full set {1} problem

[#1]

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]))

[IAMDV]

Hi Chris,

It would be easy if you can share the sample QVW.

Cheers,

DV

www.QlikShare.com

[MK_QSL]

Can you provide sample apps or dummy data please?

[#4]

Maybe check TOTAL or ALL qualifiers.

regards

Darek

[#5]

Hi, I can't share it due to confidentiality sorry.

[IAMDV]

How about this expression?

=max({1} aggr(sum({1} aggr(sum({1} [Savings])*((round(avg({1} [Question Response]))-1)/4),[Question Number], [Unique ID])),[Unique ID]))

Cheers,

DV

www.QlikShare.com

[#7]

Hi Deepak, sorry that still does not ignore the current selections.

Chris

[#8]

Hi Dariusz,

Thanks, I have tried that but it just gives the same result for every data point and still does not ignore the selections.

Chris

[#9]

I am going to start with the middle part of the expression and try to get that working first and then put the next part around it. I will post it here if I fix it

[#10]

Hi Deepak,

I finally got this working. I built it up again from scratch so I am not sure which bit fixed it. I think it was changing the average to a sum, which did not change the result because it was only every averaging or summing over a single record.

=sum({$<Industry=,[Account Name]=,[Unique ID]=,[Country Region]=>}aggr(sum({$<Industry=,[Account Name]=,[Unique ID]=,[Country Region]=>}[Productivity]

*(()-1)/4),[Question Number],[Unique ID]))