Mistake in expression

[smilingjohn]

Hi All, 

I have a below epression which is giving red higligh can anyone please help me on this. 

=sum(aggr(sum({<Date>}aggr({<Date>} if(count({<Date>}ID)>0,count({<Status={'Open'},Date>}ID),
above(total column(1))),(Date, (NUMERIC, ASCENDING)))),Date))* avg(1)

Thanks in Advance

[MindaugasBacius]

Check the links below:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

[sunny_talwar]

Why are you doing Sum(Aggr()) twice? Try this

=Sum({<Date>}Aggr(If(Count({<Date>}ID) > 0, Count({<Status={'Open'}, Date>} ID), Above(TOTAL Column(1))), (Date, (NUMERIC, ASCENDING))))
*
Avg(1)

[Kushal_Chawda · Accepted solution]

This is probably the question regarding my reply here

https://community.qlik.com/t5/New-to-QlikView/Weekend-counts/m-p/1728683#M391298

set within Aggr works fine within Qlik sense as I was working in qlik sense. But if it doesn't work for you in QlikView then you can remove it and try what @sunny_talwar suggested