topic Re: Set analysis full set {1} problem in QlikView

Set analysis full set {1} problem

Thu, 11 Sep 2014 08:46:37 GMT

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

Re: Set analysis full set {1} problem

IAMDV — Thu, 11 Sep 2014 08:54:37 GMT

Hi Chris,

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

Cheers,

www.QlikShare.com

Re: Set analysis full set {1} problem

MK_QSL — Thu, 11 Sep 2014 08:54:41 GMT

Can you provide sample apps or dummy data please?

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 08:57:08 GMT

Maybe check TOTAL or ALL qualifiers.

regards

Darek

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 08:57:57 GMT

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

Re: Re: Set analysis full set {1} problem

IAMDV — Thu, 11 Sep 2014 09:08:16 GMT

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,

www.QlikShare.com

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 09:12:56 GMT

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

Chris

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 09:17:53 GMT

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

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 09:30:14 GMT

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

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 14:52:14 GMT

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

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 14:52:50 GMT

Thanks to all of you who helped on this

Re: Set analysis full set {1} problem

Thu, 11 Sep 2014 15:10:40 GMT

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