Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

concat several sum expressions values

Hi everybody, does anybody know if is there a way to achive the following string:

(150,200,300) asuming that these 3 values are the result of three expressions with a given date(vDateRotura)

sum({<CalendarDate={"$(=max(date(vDateRotura-1)))"}> }  Qty)

sum({<CalendarDate={"$(=max(date(vDateRotura-2)))"}> }  Qty)

sum({<CalendarDate={"$(=max(date(vDateRotura-3)))"}> }  Qty)

I think that I should you use the CONCAT  function with this expression in some way using this expression, and maybe the RANK??

sum({<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> }  Qty)

Thanks in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I finally found it with this one

=concat ( IF( aggr ( Rank( sum({<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> } Qty)),CalendarDate)<=3, aggr(sum(Qty),CalendarDate) & chr(10)))

Hope can be useful

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I finally found it with this one

=concat ( IF( aggr ( Rank( sum({<CalendarDate={">=$(=max(date(vDateRotura-3)))<=$(=max(date(vDateRotura-1)))"}> } Qty)),CalendarDate)<=3, aggr(sum(Qty),CalendarDate) & chr(10)))

Hope can be useful