Count distinct

[#1]

Hi All,

I'm new to Qlikview. I have loaded all the data, but want to create a chart that gives me the average of the Totals of Y1, Y2 and Y3.

In this sample I would need to have the sum of everything divided by 3.

Serial Numbers	X1	X2
Y1	1.2	5.1
Y1	5.1	2.6
Y1	4.2	6.5
Y2	6.9	3.3
Y2	2.1	3.7
Y2	7.4	8.4
Y3	5.8	8.6

I tried to do this +sum(x1)/count([DISTINCT][Serial Numers])  but it's not working.

Do you know how to use count discriminating the equal values?

Thank you!

Victor

[sunny_talwar · Accepted solution]

The expression should have worked... I am getting 10.9 with the above expression

or you can try this

=Avg(Aggr(Sum(X1), [Serial Numbers]))

[Anil_Babu_Samineni]

What are you expecting from given data?

[#4]

Ah, I wasn't using the parenthesis correctly...

Thank you!!

[swuehl]

Right, the square brackets around TOTAL (as shown e.g. in some HELP texts) is only saying that's an optional part of the function, not that it should be printed:

What is Backus-Naur formalism? ‒ QlikView

Easy to get it wrong...