topic Re: Aggr() in QlikView

Aggr()

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

HI,

Can some one help me here .

i wrote a below expression

Num(Avg(Aggr(Avg([SVT GDC TAT NumValue]), [SVT GDC TAT ID])),'#,##0' )

but when i look at the numbers each project ID i am getting right number but when i do over all average its not getting it correct as per below snapshot

When i export to excel and checked overall average is 36.41 as per below snapshot but i am getting as 14.56 . any idea why ?

Re: Aggr()

jonathandienst — Mon, 04 Mar 2019 10:39:00 GMT

Are the dimensions of your table include in the Aggr() function? It seems that the inner Aggr() is returning some zero values which are pulling the outer average down, and you may be suppressing the zeroes in that table. Try doing this in a text box to see whether you are getting that record numbers that you expect:

Count(Aggr(Avg([SVT GDC TAT NumValue]), [SVT GDC TAT ID]))

Re: Aggr()

dunnalahk123 — Mon, 04 Mar 2019 11:03:05 GMT

Hi Jonty,

Thank You for your response.

no still tis not working.

Re: Aggr()

dunnalahk123 — Mon, 04 Mar 2019 12:57:35 GMT

HI Jonty,

You are right . the projects where it is "0" is getting suppressed due to option checked in presentation tab "Suppress Zero values".

Re: Aggr()

dunnalahk123 — Mon, 04 Mar 2019 13:40:38 GMT

Hi Jonty,

You are right . the projects where it is "0" is getting suppressed due to option checked in presentation tab "Suppress Zero values".

is there a way to write expression to get "0" values

Re: Aggr()

Sue_Macaluso — Mon, 04 Mar 2019 15:49:38 GMT

Is this referring to QlikView or Sense? I'd like to move it into the correct product forum. This one is typically for general discussion and moving it will get more people to see it in the product forum

Re: Aggr()

dunnalahk123 — Mon, 04 Mar 2019 17:59:37 GMT

HI,

It is For Qlikview.

Thank You.