topic Re: Only count where this not that in QlikView

Only count where this not that

Anonymous — Fri, 06 Nov 2015 00:30:15 GMT

Hi, This returns (count) 1 for Site when p Part_Number exist at a site but -p does not. It returns 0 otherwise. I would like to include an IF statement to ONLY return a value if p exists but -p does not.

Essentially, I am not interested in the 10,000 site_id_key where both items exist (Or p does not) - only the 25 where p exists but -p does not.

count({$<Site_Id_Key= p({$<Part_Number={'45133403129',
'45133403130',
'45133405029'
}>} Site_Id_Key)
- p({$<Part_Number={'1021931',
'8000826',
'45133308034',
'45133308530'
}>} Site_Id_Key)>}Distinct Site_Id_Key)

Re: Only count where this not that

sunny_talwar — Fri, 06 Nov 2015 00:37:26 GMT

See if this works:

=Count({<Site_Id_Key= p({<Part_Number={'45133403129', '45133403130', '45133405029'}>}Site_Id_Key) * e({<Part_Number={'1021931', '8000826', '45133308034', '45133308530'}>} Site_Id_Key)>}Distinct Site_Id_Key)

Re: Only count where this not that

Anonymous — Fri, 06 Nov 2015 00:43:16 GMT

Bingo, thank you. Looking for a job?

Re: Only count where this not that

sunny_talwar — Fri, 06 Nov 2015 00:44:27 GMT

Hahahaha no, not right now, but may be in the future