topic Re: count in QlikView

count

realpixel — Sat, 07 Dec 2013 11:24:15 GMT

Hello,

Under a part of my chart.

I want to count the column “LOCATIONS” with fields “IMMAT” and “DATE” only once

In case, only once, because the date is the same 29/11/2013 and the IMMAT is the same (301)

DATE	IMMAT	HEURE	LOCATIONS
29/11/2013	301	23:14:09	SOCO
29/11/2013	301	23:14:30	SOCO
29/11/2013	301	12:45:54	SOCO
29/11/2013	301	14:48:01	SOCO
29/11/2013	301	17:15:43	SOCO
			5

The result must be like that

DATE	IMMAT	HEURE	LOCATIONS
29/11/2013	301	23:14:09	SOCO
29/11/2013	301	23:14:30	SOCO
29/11/2013	301	12:45:54	SOCO
29/11/2013	301	14:48:01	SOCO
29/11/2013	301	17:15:43	SOCO
			1

Someone have an idea?

Re: count

afurtado — Sat, 07 Dec 2013 11:35:21 GMT

Hi.

count(distinct DATE & IMMAT )

Alessandro Furtado

Re: count

realpixel — Sat, 07 Dec 2013 12:15:48 GMT

Thank you, it's works but there some value are null in "LOCATIONS" field.

How to count only the value not null?

Expression in « LOCATIONS » is

=[LOCATIONS]

I have create a new field for the expression below :

count(distinct HMDATE1 & HMIMMAT2)

DATE	IMMAT	HEURE	LOCATIONS	count(distinct HMDATE1 & HMIMMAT2)
29/11/2013	301	23:14:09	SOCO	1
29/11/2013	301	23:14:30	SOCO	1
29/11/2013	301	12:45:54	SOCO	1
29/11/2013	301	14:48:01	SOCO	1
29/11/2013	301	17:15:43	SOCO	1
			5	1

Is not possible to have expression =[LOCATIONS] combined with expression count(distinct HMDATE1 & HMIMMAT2) to have only one column like the chart under?

DATE	IMMAT	HEURE	LOCATIONS
29/11/2013	301	23:14:09	SOCO
29/11/2013	301	23:14:30	SOCO
29/11/2013	301	12:45:54	SOCO
29/11/2013	301	14:48:01	SOCO
29/11/2013	301	17:15:43	SOCO
			1

Re: count

Gysbert_Wassenaar — Sat, 07 Dec 2013 12:38:27 GMT

Try count({<LOCATIONS={'*'}>}distinct LOCATIONS)

Re: count

realpixel — Sat, 07 Dec 2013 18:26:26 GMT

Thank you for your reply.

Expression count({<LOCATIONS={'*}>}distinct LOCATIONS)

Return this error: Error in set modifier ad hoc element list

Re: count

fred_s — Sat, 07 Dec 2013 19:13:00 GMT

{'*'} or {'*}. Maybe there's one ' missing?