concat several sum expressions values

Anonymous — Fri, 22 May 2015 06:25:43 GMT

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

Re: concat several sum expressions values

Anonymous — Fri, 22 May 2015 06:31:42 GMT

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

topic Re: concat several sum expressions values in QlikView

concat several sum expressions values

Re: concat several sum expressions values