topic Re: Variable in QlikView

Variable

upaliwije — Wed, 03 Feb 2021 11:29:04 GMT

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 — Wed, 03 Feb 2021 11:52:30 GMT

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 — Wed, 03 Feb 2021 11:57:44 GMT

Thanks

I modified it like below

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

still not working

Vegar — Wed, 03 Feb 2021 12:15:43 GMT

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/aggr.htm

upaliwije — Wed, 03 Feb 2021 12:40:41 GMT

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

upaliwije — Thu, 04 Feb 2021 06:25:46 GMT

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