topic Re: count of distinct in QlikView

count of distinct

maniram23 — Wed, 22 Apr 2015 05:18:08 GMT

i have a field called period. i want count to the distinct count in script level . i don't want create in UI level test object.

amit_saini — Wed, 22 Apr 2015 05:21:19 GMT

Mani,

try this:

Count(DISTINCT CustomerCode)

sum(aggr(count( distinct MonthName(Date)), CustomerCode ))

=COUNT(TOTAL<Customer> DISTINCT Product)

Thanks,

PrashantSangle — Wed, 22 Apr 2015 05:24:35 GMT

Hi,

If you need to count in script

then in script add count(fieldname) as count_fieldName,

Note : Count is aggreated function for that you required group by clause.

Regards

maniram23 — Wed, 22 Apr 2015 05:25:17 GMT

count works in script level ?

PrashantSangle — Wed, 22 Apr 2015 05:29:25 GMT

Hi,

Yes, but it is aggreated function for that you required Group by clause.

Check below test script ;

t1:
LOAD * INLINE [
    no,ID
    23,1
    43,1
    54,2
    1000,2
    99,1
];

t2:
LOAD count(no) as count_no,
ID
Resident t1
Group by ID
;

DROP Table t1;

Regards

amit_saini — Wed, 22 Apr 2015 05:31:55 GMT

yes you can , but it should be aggr() function.

Thanks,
AS

anbu1984 — Wed, 22 Apr 2015 05:37:27 GMT

If you need distinct count of a field, you can try like this

t1:
LOAD * INLINE [
no,ID
23,1
43,1
54,2
1000,2
99,1
];

Load Count(DISTINCT ID) Group by Key;
Load 1 As Key,ID Resident t1;