topic Re: Show only Null Values Expression in QlikView

Show only Null Values Expression

Mon, 03 Jul 2017 12:20:03 GMT

I have some data with Null values to report on and unable to figure out the correct expression.

I want to see only data with NO implementation partner associated.

I'm able to see all data WITH an implementation with the following expression:

=count ({< Type = {'*Onboarding*'}, [Implementation Partner] = {'*'}>}[Success Plan: ID])

Simply adding '-=' for Implementation Partner does not produce the opposite result. For some reason this zero's out the results. Any clues, this seems like it should be easy?

Re: Show only Null Values Expression

Anil_Babu_Samineni — Mon, 03 Jul 2017 15:56:11 GMT

May be try this?

=count ({< Type = {'*Onboarding*'}, [Implementation Partner] = {' '}>}[Success Plan: ID])

Re: Show only Null Values Expression

Anonymous — Mon, 03 Jul 2017 15:59:37 GMT

=count ({$<Type = {'*Onboarding*'}> - <[Implementation Partner] = {'*'}> }[Success Plan: ID])

Re: Show only Null Values Expression

Mon, 03 Jul 2017 16:04:07 GMT

Thanks but for some reason, Anil, this brings back all data, including those WITH Partners associated.

Re: Show only Null Values Expression

Anonymous — Mon, 03 Jul 2017 16:06:58 GMT

are you sure, you're using real null() values?

Re: Show only Null Values Expression

Anil_Babu_Samineni — Mon, 03 Jul 2017 16:10:06 GMT

What if you are getting when use like below

=count ({< [Implementation Partner] = {' '}>}[Success Plan: ID])

=count ({< [Implementation Partner] = {'0'}>}[Success Plan: ID])

=count ({< [Implementation Partner] = {'-'}>}[Success Plan: ID])

=count ({< [Implementation Partner] = {"=Len([Implementation Partner])>0"}>}[Success Plan: ID])