# Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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

Nicolas

Tags (4)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: sum if max problem

May be this

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

2 Replies
Highlighted
MVP

## Re: sum if max problem

May be this

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

Highlighted
Not applicable

## Re: sum if max problem

it works, thanks a lot Sunny