Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

sum if max problem

Hello all,

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:


DateProductSalesLast day sales
25/5/2017Apple25k$0$
25/5/2017Bananas30k$0$
28/5/2017Oranges65k$65k$
28/5/2017Apple21k$21k$


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,

Nicolas

1 Solution

Accepted Solutions

Re: sum if max problem

May be this

Sum(Aggr(If(Date = Max(TOTAL <Product> Date), Sales), Product, Date))

View solution in original post

2 Replies

Re: sum if max problem

May be this

Sum(Aggr(If(Date = Max(TOTAL <Product> Date), Sales), Product, Date))

View solution in original post

Not applicable

Re: sum if max problem

it works, thanks a lot Sunny