Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

carlospulgarinz
New Contributor

Select a null value

Good afternoon, I need to select the NULL values in this table, Can someone helpme please!!

Screenshot_1.png

1 Solution

Accepted Solutions
MVP
MVP

Re: Select a null value

You can't select NULL, it's not a value / symbol you can select.

It seems that your record set shows identificacion  values that have no relation to Ca... (what ever your dimension field is named like) field values.

If you want to identify these identificacion values (or other related field values like a primary key ID), you can first select all Cam.. values, i.e. Inbound, Mail, Outbound, Ubicabilidad and then select the exluded values on field identificacion.

7 Replies
MVP
MVP

Re: Select a null value

You can't select NULL, it's not a value / symbol you can select.

It seems that your record set shows identificacion  values that have no relation to Ca... (what ever your dimension field is named like) field values.

If you want to identify these identificacion values (or other related field values like a primary key ID), you can first select all Cam.. values, i.e. Inbound, Mail, Outbound, Ubicabilidad and then select the exluded values on field identificacion.

carlospulgarinz
New Contributor

Re: Select a null value

That, was exactly what i was looking for, Thank you

josephinetedesc
Contributor III

Re: Select a null value

Hi Stefan

I had just this question:

This works beautifully  - when I make it a  sheet Trigger

Is there a way of doing the same thing in Set Analysis?  For example

The selections are: Null, Tinted, Normal

I want :

Count(widgets) when selection = NULL or selection = NORMAL

or alternatively

Count(widgets) when selection <> Tinted

Thank you for your help

Jo

josephinetedesc
Contributor III

Re: Select a null value

just found Michael Tarallo's video - thank s all

Employee
Employee

Re: Select a null value

I can recommend this blog post if you'd like to learn more:

NULL – The Invisible Nothing

josephinetedesc
Contributor III

Re: Select a null value

Thank you

Shakespeare was wrong - There is much ado about nothing!

Jo

Employee
Employee

Re: Select a null value

Indeed! In fact "Null" is a rather controversial concept. If you really want to dig further (but I'm leaving the Qlik domain now) I can highly recommend these two blog posts:

https://ericlippert.com/2013/07/25/what-is-the-type-of-the-null-literal/

https://ericlippert.com/2013/05/30/what-the-meaning-of-is-is/

Happy reading!

Community Browser