{"id":40214,"date":"2018-11-09T16:10:19","date_gmt":"2018-11-09T10:40:19","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=40214"},"modified":"2018-11-09T16:10:19","modified_gmt":"2018-11-09T10:40:19","slug":"qlik-sense-null-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/","title":{"rendered":"Qlik Sense Null Functions – IsNULL and NULL"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

In our last Qlik Sense Tutorial<\/strong>, we discussed Qlik Sense Mapping Functions<\/a><\/strong>. In this Qlik Sense Null Functions tutorial, we will talk about NULL functions which we use to detect and return NULL values, if present in the data record. You were introduced to the concept of NULL values in the QlikView<\/strong> <\/a>tutorials. So, the null values are such places or cells in a data table or record which contain no data value of any sorts and are thus called NULLs or nothingness. Even though they contain no value, these values are of some significance in Qlik Sense, and for that, the two functions, IsNull() function and NULL() functions. \u00a0<\/span><\/p>\n

So, let’s start Qlik Sense Null Functions Tutorial.<\/p>\n

\"Qlik<\/a>

Qlik Sense Null Functions – IsNULL and NULL<\/p><\/div>\n

2. Qlik Sense Null Functions<\/h2>\n

i. IsNull() function<\/span><\/h3>\n

The IsNull() function checks the values for Null and returns -1 (True) if it is Null and 0 (False) if it is not Null. This function evaluates an expression logically and answers in -1 or 0.<\/span><\/p>\n

Have a look at Qlik Sense Scatter Plot<\/a><\/strong><\/p>\n

The syntax of Qlik Sense IsNull Function<\/span>:<\/span><\/p>\n

IsNull(expression)<\/pre>\n
For example, we load a table inline called NullsDetect where we have loaded some values in two columns and four rows where some actual data values and some null values have been loaded. Now, the resultant table which will be made will have three columns, for ID, Value and IsItNull which returns T if a value is Null and F if it is not. <\/span><\/p>\n
NullsDetect:\r\nLOAD *,\r\nIf(IsNull(Value), 'Yes', 'No\u2019) as IsItNull;\r\nLOAD * Inline\r\n[ID, Value\r\n0,\r\n1,NULL\r\n2,-\r\n3,Mark];<\/pre>\n
Resultant table,<\/span><\/p>\n\n\n\n\n\n\n\n
ID<\/b><\/td>\nValue<\/b><\/td>\nIsItNull<\/b><\/td>\n<\/tr>\n
0<\/span><\/td>\n<\/td>\nYes<\/span><\/td>\n<\/tr>\n
1<\/span><\/td>\nNULL<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
2<\/span><\/td>\n–<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
3<\/span><\/td>\nMark<\/span><\/td>\nNo<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
So, in the sample code given, the IsNull(Value) function first evaluates the values in the column \u2018Value\u2019 to detect Null. And then in the resultant table, we get three Ts because first three values are Null and the last one \u2018F\u2019 as Mark is a string value and not a Null value. In the system\u2019s logic the True or T is recorded as -1 and False, or F is returned as 0. <\/span><\/p>\n
ii. NULL() function <\/span><\/h3>\n
This function returns a null value. It is different from IsNull function as that returns a logical answer in True or False, whereas NULL() function returns \u2018-\u2018 in place of a null value.<\/span><\/p>\n
Do you know about Qlik Sense Line Chart<\/a><\/strong><\/p>\n
The syntax of Qlik Sense Null Functions<\/span>:<\/span><\/p>\n
Null()<\/pre>\n
For instance, <\/span><\/p>\n
In the script given below, we will use the values in the column \u2018Value\u2019 in the table loaded inline which are a mix of nulls and other (numeric or string) values. Using the Null() function, we will see which values are actually null and which are not. <\/span><\/p>\n
NullsConvert:\r\nLOAD *,\r\nIf(len(trim(Value))= 0 or Value='NULL' or Value='-', Null(), Value ) as ValueNullConv;\r\nLOAD * Inline\r\n[ID, Value\r\n0,\r\n1,NULL\r\n2,-\r\n3,29\r\n4,Mark];<\/pre>\n
Resultant table,<\/span><\/p>\n\n\n\n\n\n\n\n\n
ID<\/b><\/td>\nValue<\/b><\/td>\nValueNullConv<\/b><\/td>\n<\/tr>\n
0<\/span><\/td>\n<\/td>\n–<\/span><\/td>\n<\/tr>\n
1<\/span><\/td>\nNULL<\/span><\/td>\n–<\/span><\/td>\n<\/tr>\n
2<\/span><\/td>\n–<\/span><\/td>\n–<\/span><\/td>\n<\/tr>\n
3<\/span><\/td>\n29<\/span><\/td>\nValue<\/span><\/td>\n<\/tr>\n
4<\/span><\/td>\nMark<\/span><\/td>\nValue<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Thus, as you can see in the table, the data values in the field \u2018Value\u2019 gets evaluated by the Null() function which returns \u2018-\u2018 if a null is encountered and returns \u2018Value\u2019 if a string or numeric value is encountered.<\/span><\/p>\n
Let’s revise Qlik Sense Conditional Functions<\/a><\/strong><\/p>\n
So, this was all in Qlik Sense Null Functions. Hope you like our explanation.<\/p>\n
3. Conclusion <\/span><\/h2>\n
Thus, in this Qlik Sense Null Functions article, we learned about how the two null functions deal with null values. As the IsNull() is a function that logically evaluates a set of values and returns -1 or 0 for if a value is null or not. On the other hand, the Null() function detects the null values from a data set and returns \u2018-\u2018 symbol in its place.<\/span><\/p>\n
Still, if you have any query regarding\u00a0Qlik Sense Null Functions, ask in the comment tab.<\/p>\n
See also –\u00a0<\/strong><\/p>\n
Qlik Sense Gauge Chart<\/a><\/strong><\/p>\n
Reference for Qlik Sense<\/a><\/strong>
1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense Mapping Functions. In this Qlik Sense Null Functions tutorial, we will talk about NULL functions which we use to detect and return...<\/p>\n","protected":false},"author":6,"featured_media":40528,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17588,17587,17589,17586],"class_list":["post-40214","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-isnull-function","tag-null-functions-in-qlik-sense","tag-qlik-sense-isnull-function","tag-qlik-sense-null-functions"],"yoast_head":"\nQlik Sense Null Functions - IsNULL and NULL - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Null Functions,Qlik Sense isnull expression,Qlik Sense is not null,Qlik Sense null values,isnull Function in Qlik sense\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Null Functions - IsNULL and NULL - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Null Functions,Qlik Sense isnull expression,Qlik Sense is not null,Qlik Sense null values,isnull Function in Qlik sense\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-09T10:40:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Null-Functions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Null Functions - IsNULL and NULL - DataFlair","description":"Qlik Sense Null Functions,Qlik Sense isnull expression,Qlik Sense is not null,Qlik Sense null values,isnull Function in Qlik sense","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Null Functions - IsNULL and NULL - DataFlair","og_description":"Qlik Sense Null Functions,Qlik Sense isnull expression,Qlik Sense is not null,Qlik Sense null values,isnull Function in Qlik sense","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-09T10:40:19+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Null-Functions.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Null Functions – IsNULL and NULL","datePublished":"2018-11-09T10:40:19+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/"},"wordCount":616,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Null-Functions.jpg","keywords":["IsNull() function","Null Functions in Qlik Sense","Qlik Sense IsNull Function","Qlik Sense Null Functions"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/","name":"Qlik Sense Null Functions - IsNULL and NULL - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Null-Functions.jpg","datePublished":"2018-11-09T10:40:19+00:00","description":"Qlik Sense Null Functions,Qlik Sense isnull expression,Qlik Sense is not null,Qlik Sense null values,isnull Function in Qlik sense","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Null-Functions.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Null-Functions.jpg","width":1200,"height":628,"caption":"Qlik Sense Null Functions - IsNULL and NULL"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Null Functions – IsNULL and NULL"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=40214"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40214\/revisions"}],"predecessor-version":[{"id":41716,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40214\/revisions\/41716"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/40528"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=40214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=40214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=40214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}