https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idi-p/1500041 <P style="font-size: 14px; margin: 10px 0; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">The Qlik Sense logic treats the following as real NULL values:</SPAN></P> <UL> <LI><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">NULL values returned from an ODBC connection</SPAN></LI> <LI><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">NULL values created as a result of a forced concatenation of tables in the data load script</SPAN></LI> <LI><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">NULL values created as a result of a join made in the data load script</SPAN></LI> <LI><SPAN style="color: #ff0000; font-size: 10pt; font-family: arial, helvetica, sans-serif;">NULL values created as a result of the generation of field value combinations to be displayed in a table</SPAN></LI> </UL> <P>&nbsp;</P> <P>For the last case, we need an option in the presentation options to label these nulls.</P> <P>&nbsp;</P> <P>I often come up against this in complicated data models and need to show these nulls to the user to maintain the integrity of the data but also label these nulls in a way that is meaningful to the user.</P> Wed, 25 Nov 2020 15:35:02 GMT mjones87 2020-11-25T15:35:02Z https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idc-p/1650950#M1465 Mon, 25 Nov 2019 21:13:35 GMT https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idc-p/1650950#M1465 Anonymous 2019-11-25T21:13:35Z https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idc-p/1668955#M1466 Fri, 24 Jan 2020 13:31:50 GMT https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idc-p/1668955#M1466 John_Teichman 2020-01-24T13:31:50Z https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idc-p/1671139#M1467 <P>Closing this item - two other ideas are basically the same as this one:</P> <P><A href="https://community.qlik.com/t5/Qlik-Sense-Ideas/Improved-NULL-value-handling/idi-p/1623048" target="_blank">https://community.qlik.com/t5/Qlik-Sense-Ideas/Improved-NULL-value-handling/idi-p/1623048</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Sense-Ideas/Select-null-values/idi-p/1598555" target="_blank">https://community.qlik.com/t5/Qlik-Sense-Ideas/Select-null-values/idi-p/1598555</A></P> Fri, 31 Jan 2020 06:18:37 GMT https://community.qlik.com/t5/Suggest-an-Idea/Null-value-labels-in-tables/idc-p/1671139#M1467 John_Teichman 2020-01-31T06:18:37Z