topic Re: How to exclude null values in set analysis in QlikView

How to exclude null values in set analysis

Thu, 04 Dec 2014 19:01:22 GMT

I am trying to exclude null values from my set analysis equations below. Below are my current equations,

CURRENT Set Analysis Expression:

Wins:

=count({$<StatusID={'$(vWonStatusID)'}, StatusSummary =>}DISTINCT IncidentID)

Loss:

=num(count({$<CreatedDate>}Distinct IncidentID), '#,##0')

count({$<StatusID={'$(vWonStatusID)'}, StatusSummary =>}DISTINCT IncidentID)

Total:

=num(count({$<CreatedDate>}Distinct IncidentID), '#,##0')

Thanks

Re: How to exclude null values in set analysis

Anonymous — Thu, 04 Dec 2014 19:07:22 GMT

Hi Toedtli,

add below code in script and replace field EmpID with your own fields:

if(Len(Trim(EmpID))= '0',1,0) as CountID.

add in UI:

=count({<CountID ={'1'}>} EmpID)

Regards

Neetha

Re: How to exclude null values in set analysis

mato32188 — Thu, 04 Dec 2014 19:09:53 GMT

Hello T.,

change your variable into vWonStatusID = if(isnull(StatusID), 0, 'yourexpectedvaluelike1yesoranythingelse') if your statusID of wins is not 0 actually...

Re: How to exclude null values in set analysis

Thu, 04 Dec 2014 19:20:55 GMT

How are nulls formatted in your data?

Re: How to exclude null values in set analysis

ruben_lima — Wed, 12 Jul 2017 16:08:43 GMT

Hi, try this

count({<EmpID -={"$(=null())"}>} EmpID)

Regards

Ruben Lima

Re: How to exclude null values in set analysis

jmvilaplanap — Wed, 12 Jul 2017 16:31:03 GMT

If the null is in the set analysis you can compare it to '' (nothing)