topic Re: Alternate State whit Set Analysis in QlikView

Alternate State whit Set Analysis

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

Hey Community,

im usin 3 group whit Alternate State and my problem is that i need to show at the Pivot table the sum of value for what was selected in each group from above,

e.g

Group 1 > The client choose Country A and if he will choose formula 1 it will show formula 1, if he will choose formula 2 it will show 2 and if he choose nothing it will show 1+2 .

the same for all the groups.

Thanks in advance

Re: Alternate State whit Set Analysis

tresB — Tue, 24 May 2016 07:03:59 GMT

Try expression:

Sum({Group1}Value)+Sum({Group2}Value)+Sum({Group3}Value)

Re: Alternate State whit Set Analysis

Tue, 24 May 2016 09:11:24 GMT

look at attached qvw.

Re: Alternate State whit Set Analysis

sunny_talwar — Tue, 24 May 2016 09:19:43 GMT

Can this also work (in all scenarios)?

Sum({Group1+Group2+Group3}Value)

Re: Alternate State whit Set Analysis

sunny_talwar — Tue, 24 May 2016 09:27:05 GMT

Now that I think about it, the two expressions might give different output.

Sum({Group1}Value)+Sum({Group2}Value)+Sum({Group3}Value)

This will sum the Value twice or thrice if it comes into selection for two or three Groups.

Sum({Group1+Group2+Group3}Value)

This will only combine all the selection and show the Value once.

Did I interpret this correctly?

Re: Alternate State whit Set Analysis

Anonymous — Tue, 24 May 2016 10:38:17 GMT

I try this

=Aggr(Sum({Group1}CIF_PRICE_VALUE)+Sum({Group2}CIF_PRICE_VALUE)+Sum({Group3}CIF_PRICE_VALUE)+Sum({Group4}CIF_PRICE_VALUE)+Sum({Group5}CIF_PRICE_VALUE),COUNTRY,Period_DESC)

It must use agrr

Re: Alternate State whit Set Analysis

Anonymous — Tue, 24 May 2016 10:45:16 GMT

Thank you but i use the function agrr becuse the sum was not correct for each country

but your help was more them ok !