topic Count in set analysis in QlikView

Count in set analysis

chaitanyajami — Fri, 04 Nov 2016 05:35:46 GMT

Hi all,

I want to calculate the number of MDM ID'd that have call count ( count(src_cal_nm)>0) greater than "0", i am using below expression but could not achive it, can some one suggest me with the correct formula to achieve it.

count({<src_call_nm-={"$(Null())"}}>}distinct [MDM ID])

count({<[MDM ID] = {"=Count([src_call_nm])>0"}>} distinct [MDM ID] )

Re: Count in set analysis

tresB — Fri, 04 Nov 2016 06:39:04 GMT

Try like:

count({<src_call_nm= {"=Len(trim(src_call_nm))>0"}>} distinct [MDM ID] )

Re: Count in set analysis

jonathandienst — Fri, 04 Nov 2016 06:43:51 GMT

Tresesco's solution should work, but you might also be able to use:

Count({<[MDM ID] = {"=$(=Count([src_call_nm])>0")}>} distinct [MDM ID])

But this depends on the relationship between the two fields - does the count differ for each distinct MDM ID value?

Re: Count in set analysis

sushil353 — Fri, 04 Nov 2016 06:45:37 GMT

Try :

count({<src_call_nm-={' '}>}distinct [MDM ID])

count({<src_call_nm={">=$(Len(trim(src_call_nm)))"}>}distinct [MDM ID])

HTH

Sushil

Re: Count in set analysis

chaitanyajami — Fri, 04 Nov 2016 08:10:30 GMT

Hi Jonathan,

Yes those are related fields, one ID may have more than one call id, i need to calculate number of mdm id's that have call count greater than 0

Re: Count in set analysis

chaitanyajami — Fri, 04 Nov 2016 11:28:29 GMT

Thanks a ton, Its working fine

Re: Count in set analysis

chaitanyajami — Fri, 04 Nov 2016 11:28:47 GMT

Thanks a ton, Its working fine