topic Re: How do I select one field and exclude another? in QlikView

How do I select one field and exclude another?

Thu, 27 Sep 2012 14:25:04 GMT

I have one field that says 'Referral Date' which has a list of dates when people were referred to our prorgam. Those that were eligible for our program are placed and we have a field called 'Placed Date.' I want to write an expression to count the number of people that were referred (i.e. count(Referred_Date)) and exclude the number of placed date (that would give me the number of people that were Closed (i.e. referred to our program but not placed).

Any ideas? Really have no idea on this one....

Re: How do I select one field and exclude another?

swuehl — Thu, 27 Sep 2012 14:40:05 GMT

Maybe just

=count(Referred_Date)-count(Placed_Date)

Re: How do I select one field and exclude another?

Thu, 27 Sep 2012 14:43:13 GMT

I feel like an idiot haha that actaully would give me what I want.

Thanks

Re: How do I select one field and exclude another?

Thu, 27 Sep 2012 14:43:58 GMT

Try this

Count(RefDate)-Count(PlaceDate)

Re: How do I select one field and exclude another?

Thu, 27 Sep 2012 14:49:26 GMT

Yup! Thanks

Re: How do I select one field and exclude another?

qliksus — Thu, 27 Sep 2012 14:51:10 GMT

How is your Referred Date and Placed Date value is stored for a Person

count(if ( isnull(placed date) , reffrreddate) )

if the data is stored like if a person is reffred and not placed then the placed date will be null so the above expressio will work if the data is stored differently let me know so that we can change the logic

Re: How do I select one field and exclude another?

Thu, 27 Sep 2012 14:53:54 GMT

That is exactly what I was trying to do. Worked perfectly. The isnull function is what I was searching for.

::Two thumbs up::