topic Re: Sum variables with set analysis in QlikView

Sum variables with set analysis

alwinsch — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

how do i make a sum with set analysis, that uses a variable that also is a sum with set analysis.

for example

Vcomm = sum({<Type = {1,2}> Comm}

and know i want to use this variable in the following expression:

Sum({<Year = {2016}>} $(Vcomm) )

But it does not work, although the syntax of the expression is correct.

How can i resolve this? I use the Variable Vcomm in many different graphs and tables, so i cannot change it.

Kind regards,

Alwin

Re: Sum variables with set analysis

marcus_sommer — Tue, 23 Aug 2016 08:06:17 GMT

In this way you tried to nest aggregations which aren't allowed without the use of an aggr-wrapping. I'm not sure if it's make much sense to implement this instead of simply using:

Sum({<Year = {2016}, Type = {1,2}>} Comm )

- Marcus

Re: Sum variables with set analysis

alwinsch — Tue, 23 Aug 2016 08:24:03 GMT

and how does this aggr_wrapping work? Because my variable is in real life not that simple as described above.

-Alwin

Re: Sum variables with set analysis

marcus_sommer — Tue, 23 Aug 2016 08:35:10 GMT

It would need to look something like this:

Vcomm = aggr(sum({<Type = {1,2}>} Comm), Dim1, Dim2)

Sum({<Year = {2016}>} $(Vcomm) )

For this you will need to specify the dimensions in which relation the inner aggregation should be performed and this kind of expression needs a lot more performance than a normal set analysis expression and you shouldn't use them if they aren't mandatory necessary: When should the Aggr() function NOT be used?

I think you could rather need variables with parameter. This and many more about variables could you find here: Variables.

- Marcus

Re: Sum variables with set analysis

alwinsch — Wed, 24 Aug 2016 08:17:45 GMT

thanks for the help,

i did it the easy way, without aggr and followed your first post.

-Alwin