Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr function problem !!!

Hi all,

I encounter a problem in using aggr. Hope someone can give me some help, much appreciate!

Imagen1.png

How do I get the first expression of the same result as the second expression?

Attached Example  Aggr.qvw


PS: Sorry for my English

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with (and check it!)

Sum({$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"}   >}

Aggr(SUM( {$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"}   >}

Sales ),Group, Id, Description,Type))

View solution in original post

2 Replies
maxgro
MVP
MVP

try with (and check it!)

Sum({$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"}   >}

Aggr(SUM( {$< AÑO=, MES= , Date = {"<=$(=DATE(MonthEnd(Max(Date))))"}   >}

Sales ),Group, Id, Description,Type))

Not applicable
Author

Excellent !!

Thank you very much