topic Mistake in expression in QlikView

Mistake in expression

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Mistake in expression

MindaugasBacius — Fri, 17 Jul 2020 05:57:30 GMT

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/SetAnalysis/set-analysis-expressions.htm

Re: Mistake in expression

sunny_talwar — Fri, 17 Jul 2020 11:47:13 GMT

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)

Re: Mistake in expression

Kushal_Chawda — Fri, 17 Jul 2020 14:13:02 GMT

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