Average Total for all rows

[qlikview979]

Hi Experts,

For your reference i am attaching snapshot.

Here i want show them the total average(95.3) in all rows.which is showing in snapshot with black mark.

My expression is

Count(DISTINCT UNIX_ID_GOV)/

Count(DISTINCT total UNIX_ID_RST)

Expected Output:-

theresaa‌

Regards

Mahesh

[qlikview979]

Hi Bro,

we don't have null values in dimension level .

[jubarrosor]

Ouch!

Sorry:

Count(total<MonthName> DISTINCT UNIX_ID_GOV) / Count(total<MonthName>DISTINCT total UNIX_ID_RST)

[qlikview979]

sorry bro,

its not working

[sunny_talwar]

Have you unchecked 'Include Zero Value' from your MonthName dimension? Can you check it, if it is unchecked?

[qlikview979]

Yes, please find the attached Sample data .

[jubarrosor]

Sorry friend:

avg(total aggr(sum( DISTINCT  UNIX_ID_GOV)/  sum(total DISTINCT  UNIX_ID_RST), Mes))

Best Regards,
Juan P. Barroso

[sunny_talwar]

This is a pre-aggregated data (looks like an export from your chart) so I can't really use it for anything .

Do you have a calculated dimension?

[qlikview979]

Hi Bro Thanks for ur reply,

Instead of SUM i have  used COUNT in expression level, but here instead of 95.3 it is showing  88.8

I have attached sample if its possible  can you check it.

Regards

Mahesh

[qlikview979]

Hi Bro,

i don't have any calculated dimension.

[sunny_talwar]

No idea, would you be able to share a qvf sample?