Use Alternate state in expression with aggr

[Anonymous]

Dear Community,

i have following expression:

SUM(aggr(DISTINCT(AMOUNT),SN,DATE,AMOUNT))

And the alternate state:

X

Now i want to transform this expression so it runs under the alternate state X

I tried :

sum({X} aggr(DISTINCT(AMOUNT),SN,DATE,AMOUNT))

But the aggreagate is not working over this alternate state

Please help!

[Anonymous]

Does not help me, if i switch the alternate state of the object to the desired one it works.

But the state of the object needs to stay untouchd, the alternate state needs be passed to the aggregate, thats what i am struggeling with

[avinashelite]

Hi,

Every tool has certain limitations and similarly even with Qlikview.  This is one of the cases

[kuba_michalik]

I'm not sure if it's possible to look at it properly without an example qvw.

I whipped up a quick test case and it seems to work, whether you stick the alternate state set expression in the outer or in the inner aggregation function (so I put it in both )

[sasiparupudi1]

Please post your qvw here