topic Re: Count function in QlikView

Count function

danialier — Tue, 18 Feb 2014 13:46:15 GMT

Hello,

I have a group of five products as follows:

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

Re: Count function

Tue, 18 Feb 2014 13:48:08 GMT

You can use count (Distinct Product).

Re: Count function

alexandros17 — Tue, 18 Feb 2014 13:48:16 GMT

Count( DISTINCT Item)

Re: Count function

MK_QSL — Tue, 18 Feb 2014 13:48:19 GMT

count(DISTINCT Product)

Re: Count function

Tue, 18 Feb 2014 13:49:35 GMT

Count(Distinct Product)

Re: Count function

Tue, 18 Feb 2014 13:56:32 GMT

=Count(Distinct Product)

Re: Count function

Tue, 18 Feb 2014 13:57:41 GMT

i think your problem is Solved mark this question as Answered

Re: Count function

hic — Tue, 18 Feb 2014 14:13:23 GMT

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

Re: Count function

giakoum — Tue, 18 Feb 2014 14:33:53 GMT

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?

Re: Count function

hic — Wed, 19 Feb 2014 07:14:53 GMT

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

Re: Count function

giakoum — Wed, 19 Feb 2014 07:39:18 GMT

Thank you HIC.

I deleted my reply so that I do not confuse anybody.