topic Re: count conditional in QlikView

count conditional

Fri, 31 Aug 2012 20:23:06 GMT

Hello,

i need count some rows

example

DATE	NAME	EQUIP NAME	KIND OF ACTIVITY	START ACTIVITY	STATUS
31-8-12	HELMAN1	BOGOTA 1	M.P	22:00	OK
31-8-12	HELMAN1	BOGOTA 1	M.P	23:00	OK
1-9-12	WILMAR	BOGOTA 2	EMERGENCY	08:00	PENDING
1-9-12	LEONARDO	BOGOTA 3	TEST	07:00	PENDING

I need count the rows that have the same information as one row.

i have this comand line

Count

(DISTINCT [Kind of Activity]&Date&[Equipment Name])

With this i count the number of activties, but i need to add other condition that if de STATUS column is OK, the activity must to be count.

thank you.

Fri, 31 Aug 2012 20:38:17 GMT

Hai,

you can use set analysis like

=Count({$<STATUs={"OK"}>}Kind Of Activity)

are you looking for this or something else

Thanks,

Mukram.

pgalvezt — Fri, 31 Aug 2012 21:36:19 GMT

=Count({$<STATUS={"OK"}>}Distinct Kind Of Activity)

Hope Help you!

whiteline — Sat, 01 Sep 2012 07:47:30 GMT

=Count({$<STATUS={"OK"}>} [Kind of Activity]&Date&[Equipment Name])

Mon, 03 Sep 2012 00:06:43 GMT

thank you

Helman

Mon, 03 Sep 2012 00:06:58 GMT

thank you