Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()))
Thanks
I modified it like below
sum(aggr(sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}($(vSale)))))
still not working
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/...
Thanks for your advice. I still can not find a solution for my issue
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