Count function

[danialier]

Hello,

I have a group of five products as follows:

A

B

C

D

A

I need a formula that returns the number of different products, so it should return 4 (A, B, C, D). I used "count" but it gives 5 (Ax2, B, C, D).

Could you please help ?

thks,dani

[#2 · Accepted solution]

You can use count (Distinct Product).

[alexandros17]

Count( DISTINCT Item)

[MK_QSL]

count(DISTINCT Product)

[#5]

Count(Distinct Product)

[#6]

=Count(Distinct Product)

[#7]

i think your problem is Solved mark this question as Answered

[hic]

And Count(distinct ...) is not single threaded. This is a myth. See

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/22/a-myth-about-countdistinct

HIC

[giakoum]

It is not single threaded, if it is on a field in the fact table

but it is, if it is on the dimension table.

have I not understood correctly?

[hic]

There is a (usually small) phase in the chart evaluation that is single threaded, and that is when the chart "generates the combinations" over which the aggregation should be made. This affects all charts with fields from several tables, as well as those that contain Count(distinct ...). Apart from that, it is multi threaded.

HIC