Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon, I need to select the NULL values in this table, Can someone helpme please!!
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.
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.
That, was exactly what i was looking for, Thank you
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
just found Michael Tarallo's video - thank s all
I can recommend this blog post if you'd like to learn more:
Thank you
Shakespeare was wrong - There is much ado about nothing!
Jo
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!