Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Average Total for all rows

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)

Capture.PNG

Expected Output:-

Expected output.PNG

theresaa

Regards

Mahesh

21 Replies
Highlighted

Re: Average Total for all rows

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))

Highlighted
Champion III
Champion III

Re: Average Total for all rows

Not tried you can try like

= Avg(TOTAL Aggr(

                                  Count(DISTINCT UNIX_ID_GOV)

                                   /

                                  Count(DISTINCT total UNIX_ID_RST)

                               , MonthName))

Highlighted
Champion III
Champion III

Re: Average Total for all rows

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)

Highlighted
Luminary
Luminary

Re: Average Total for all rows

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

Highlighted
Specialist
Specialist

Re: Average Total for all rows

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

Highlighted
Champion III
Champion III

Re: Average Total for all rows

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

Highlighted

Re: Average Total for all rows

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

Highlighted
Specialist
Specialist

Re: Average Total for all rows

not working

Highlighted
Specialist
Specialist

Re: Average Total for all rows

yes