Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Sum(Aggr()) don't work in custom table

Hi all,

I have the following expression :

Sum(Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))

This expression sum the total accsale all store. It is ok for text box and straight table. But I use for the custom table that isnt work.

Can anyone help me??

it's straight table

Capture2.JPG

it's the custom table

Capture1.JPG

Thank in advance.

1 Solution

Accepted Solutions
MVP
MVP

Re: Sum(Aggr()) don't work in custom table

Maybe you get what you want using the TOTAL qualifier:

  //3

    ,Sum(TOTAL Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))

View solution in original post

6 Replies
MVP & Luminary
MVP & Luminary

Re: Sum(Aggr()) don't work in custom table

HI,

Try this

Sum({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>}  Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))


Regards,

Jagan.

Not applicable

Re: Sum(Aggr()) don't work in custom table

it still isnot work

kirkleehuang
New Contributor III

Re: Sum(Aggr()) don't work in custom table

I think you create a new table and add expression again hope it works

Not applicable

Re: Sum(Aggr()) don't work in custom table

kirkleehuang‌ : I try your solution but It doesnt worrk

MVP
MVP

Re: Sum(Aggr()) don't work in custom table

Maybe you get what you want using the TOTAL qualifier:

  //3

    ,Sum(TOTAL Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))

View solution in original post

Not applicable

Re: Sum(Aggr()) don't work in custom table

Hi swuehl‌ ,

Thank you so muchhhh ......