topic Re: Problem combining AGGR and Set analyses. Always want to compare to same thing in QlikView

Problem combining AGGR and Set analyses. Always want to compare to same thing

Wed, 18 Sep 2013 15:47:36 GMT

HI,

I'm having problems with building a formula. This picture shows it best.

The CALC1 field should Always be the total of the productgroup: baseset.

I've succeeded with doing that with for the first part with the formula
SUM(TOTAL <[PRODUCTGROUP]> AMOUNT)

Unfortunately I can't get it to work when the table hits the productgroup "Sales".

See the picture.

SUM(TOTAL <[PRODUCTGROUP]> {<PRODUCTGROUP={'BASESET'}>}AMOUNT) doesn't do the trick.

I've included a .qvw file with script and GUI. Can anyone help? Thanks!

CELAMBARASAN — Wed, 18 Sep 2013 16:03:59 GMT

Hi,

Use CALC1 formula as

$(=SUM( {<PRODUCTGROUP={'BASESET'}>} AMOUNT) )

Gysbert_Wassenaar — Wed, 18 Sep 2013 16:33:20 GMT

Use a helper variable. For example vTotal_BASESET: =sum({<PRODUCTGROUP={'BASESET'}>}AMOUNT)

See attached qvw.

Wed, 18 Sep 2013 18:11:57 GMT

Thanks! That solves it!

I'm absolutely surprised to see that the formula does not work when coded into the expression, but that it does work when using a variable.

Thanks!

Wed, 18 Sep 2013 18:13:36 GMT

oh wow. It seems I got 2 correct answers!

Thanks for this one too.