topic Re: Average - Total mode in QlikView

Average - Total mode

Tue, 10 Nov 2015 11:16:12 GMT

Hi,

I'm using a straight table where one of the columns is a count and the dimention limit is the top 7 users plus the others.

As a total I want the average of all users, but, using the total mode, it returns a diferent value.

It seems that it counts the others as one user.

Any suggestions?

Thanks in advance!

Re: Average - Total mode

sunny_talwar — Tue, 10 Nov 2015 12:54:10 GMT

Would you be able to share a sample? I know why it is doing this, but to suggest a work around will be better if we have a sample to work with.

Re: Average - Total mode

hic — Tue, 10 Nov 2015 12:55:56 GMT

I would use the following formula:

Count( distinct XXX ) / Count( distinct User )

If you use "User" as dimension, this will show the original number for the individual Users (divided by 1). The "Others" slice and the totals will however be divided by another number and so the expression will show the average.

HIC

Re: Average - Total mode

swuehl — Tue, 10 Nov 2015 12:57:49 GMT

Maybe use a total mode 'expression total' and as expression something like

if(Dimensionality(),

Count(YourField),

Avg( Aggr(Count(YourField), YourDimension))

)

Re: Average - Total mode

Tue, 10 Nov 2015 13:48:06 GMT

Thank you very much!!