Variable

[upaliwije]

Hi Friends

I have created following variable

vSale=sum({<RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)+sum(CS_AMOUNT)

But when I write an expression with that variable it does not show any value

My Expression  

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}($(vSale)))

Please help me to correct my error

[Vegar]

You have nested sums: sum(sum()) 

Qlikview don't allow that. A work around is to put an aggregation aggr() in between. 

Like this :  Sum (aggr(sum())) 

[upaliwije]

Thanks 

I modified it like below

sum(aggr(sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}($(vSale)))))

still not working

[Vegar]

I'm sorry, I might not been very precise .  You need an structured parameter (a field) to aggregate over when using aggr(). Take a look at this page to understand the aggr() functionality.  https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

[upaliwije]

Thanks for your advice. I still can not find a solution for my issue

[upaliwije]

I have following Pivot Table

Column 1 has the following expression

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =,RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)

Column2 has the following expression

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}$(vTsale))

My variable 

 $( vTsale)=sum({<RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)

My Column 2 does not show any value. Can you please help me to correct my Column 2  Expression