topic Re: count if expressions match in QlikView

count if expressions match

Mon, 31 Mar 2014 12:41:20 GMT

I'm not sure if I'm just missing something.

I trying to count , in this case the number of suppliers when two expressions match. Basically if the supplier scores 100% I would like to count him and in the end I'll see howmany suppliers score 100% out of a total,

appreciate the help

count(
{<
=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)
=count(DISTINCT Child_id)
>}
[leve-ki]

Re: count if expressions match

alexandros17 — Mon, 31 Mar 2014 12:44:19 GMT

I think the only way is

Count(if(count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id) = count(DISTINCT Child_id), [leve-ki], 0)

hope it helps

Re: count if expressions match

Mon, 31 Mar 2014 13:37:59 GMT

Unfortunateky thi does not work.

any other sugestions?

Re: count if expressions match

alexandros17 — Mon, 31 Mar 2014 13:42:20 GMT

and this?

if(count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id) = count(DISTINCT Child_id), Count([leve-ki]), 0)

Re: count if expressions match

Gysbert_Wassenaar — Mon, 31 Mar 2014 13:43:07 GMT

Perhaps like this:
count({<[leve-ki]={"=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)=count(DISTINCT Child_id)"}>}[leve-ki])

Re: count if expressions match

Mon, 31 Mar 2014 14:16:46 GMT

when adding distinct it works

count({<[leve-ki]={"=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)=count(DISTINCT Child_id)"}>}DISTINCT [leve-ki])

Thanks!

Could you explain why you add the part [leve-ki]= in front of the set analysis

Re: count if expressions match

Gysbert_Wassenaar — Mon, 31 Mar 2014 14:21:59 GMT

You always have to have a field name on the left side of the = sign. It means "I want to restrict the set to those values of leve-ki where count(...foo...) equals count(...bar...)"