Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like to have the sum of the last day sales only, but I have a aggr error.
I have the folowing formula for the last day value:
if(max(total Date) = max(Date) and count(distinct Date)=1, [Sales(K$)],0)
with the following result:
The result expected is merely the sum of the last day sales, but it doesn't work:
sum(if(max(total Date) = max(Date) and count(distinct Date)=1, [Sales(K$)],0))
error: Nested aggregation not allowed
Could you please help?
Thanks in advance,
May be this
Sum(Aggr(If(Date = Max(TOTAL <Product> Date), Sales), Product, Date))
View solution in original post
it works, thanks a lot Sunny