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

[sunny_talwar]

Try this

Count(TOTAL DISTINCT UNIX_ID_GOV)/

Count(TOTAL DISTINCT total UNIX_ID_RST)

or this

Avg(TOTAL Aggr(

Count(DISTINCT UNIX_ID_GOV)/

Count(DISTINCT total UNIX_ID_RST)

, MonthName))

[vishsaggi]

Not tried you can try like

= Avg(TOTAL Aggr(

                                  Count(DISTINCT UNIX_ID_GOV)

                                   /

                                  Count(DISTINCT total UNIX_ID_RST)

                               , MonthName))

[vishsaggi]

Huh!!! I am late. stalwar1‌ you cannot go against nature laws. Your responses are travelling 299 792 458 m / s...Not good. (Speed of light)

[jubarrosor]

Hi:

You can use the function total:

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

Best Regards,

Juan P. Barroso

[qlikview979]

Hi,

Thanks for ur reply,

I tried same expressions what u shared ,first expression is showing instead of  95.3 it is showing 111 for all rows

and second one is showing 88.8 for all the rows.

Regards

Mahesh

[vishsaggi]

Did you remove Avg from your Total function drop down as shown inyour snapshot. You this as your custom expression to calculate avg.

[sunny_talwar]

Do you have a null dimension which you might be suppressing?

[qlikview979]

not working

[qlikview979]

yes