Re: Use of variable in aggr - Qlik Community

Report Inappropriate Content · ‎2014-10-30

Hi All,

Can we use variable to aggregate over that defined variable. ?

Ex , I have created a variable with name vDate. I want to write sum(aggr(sum(Sales),vDate))

Thanks,

Sailee

Report Inappropriate Content · ‎2014-10-30

Hi,

sum(aggr(sum(Sales),vDate))

here you can use variable but vDate must be a Filedname not a value.

like this

set vDate=Year

sum(aggr(sum(Sales),vDate))

vikasmahajan · ‎2014-10-30

your expression is wrong

you can use like this

sum(aggr( (SUM({$< FiscalYear={$(=max(FiscalYear))},[Posting Date] = {'<=$(=Date(vDate))'}>}[Sales]) ))

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

MayilVahanan · ‎2014-10-30

Hi

Try like this

sum(aggr(sum(Sales), $(vDate)))

Hope vDate is the Field Name.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.