{"id":40326,"date":"2018-11-09T16:20:49","date_gmt":"2018-11-09T10:50:49","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=40326"},"modified":"2018-11-09T16:20:49","modified_gmt":"2018-11-09T10:50:49","slug":"qlik-sense-logical-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/","title":{"rendered":"Qlik Sense Logical Functions – IsNum and IsText"},"content":{"rendered":"

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

In our last Qlik Sense Tutorial<\/strong>, we discussed Qlik Sense Mathematical Functions<\/a><\/strong>. Today, we will see Qlik Sense Logical Functions. Moreover, we are going to study such functions which are used to perform logical operations on data values and return a reasonable value.<\/span><\/p>\n

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

\"Qlik<\/a>

Qlik Sense Logical Functions – IsNum and IsText<\/p><\/div>\n

2. Qlik Sense Logical Functions<\/span><\/h2>\n

There are two important logical functions in Qlik Sense IsNum and IsText, which we use both in Qlik Sense chart and script. Basically, these functions sort from a data table, values that are the string and those which are numeric.<\/span><\/p>\n

Have a look at Qlik Sense Null Functions<\/a><\/strong><\/p>\n

As they are logical functions, so if a data value encountered in the script is numeric such as 55, then the expression IsNum() will evaluate to be True and -1 will return as a result. But, if the value is not numeric, say, \u2018Apple\u2019 then the IsNum() function will evaluate to False and return 0 as a result to the user. <\/span><\/p>\n

The same occurs in the case of the IsText function, where it returns True or -1 when a text or string value is encountered and False or 0 when a text or string value is not encountered. So, these Qlik Sense Logical Functions use when the user is dealing with a lot of data records and values and need to sort and manage them properly based on the type of their data format<\/span><\/p>\n

i. IsNum<\/span><\/h3>\n

The IsNum() function looks for a numeric value while a script is executed and returns -1 if it encounters a numeric value and 0 when it does not encounter a numeric value. <\/span><\/p>\n

The syntax for Qlik Sense IsNum:<\/strong><\/p>\n

IsNum(expression)<\/pre>\n
Let us understand this with the help of an example, where we load some data values inline and use IsNum() function to sort numeric values from it.<\/span><\/p>\n
Do you know about Qlik Sense Mapping Functions<\/a><\/strong><\/p>\n
Load *, IsNum(Entries)\r\nInline [\r\nEntries\r\n23\r\nMike\r\nRobert\r\n40\r\n55\r\nAngela];<\/pre>\n
This will create two fields or columns in a resultant table, which is \u2018IsNum(Value)\u2019 and \u2018Entries\u2019 where -1 and 0 will show True or False for a value being numeric in nature or not respectively. <\/span><\/p>\n\n\n\n\n\n\n\n\n\n
Entries<\/strong><\/td>\nIsNum(Entries)<\/strong><\/td>\n<\/tr>\n
23<\/span><\/td>\n-1<\/span><\/td>\n<\/tr>\n
Mike<\/span><\/td>\n0<\/span><\/td>\n<\/tr>\n
Robert<\/span><\/td>\n0<\/span><\/td>\n<\/tr>\n
40<\/span><\/td>\n-1<\/span><\/td>\n<\/tr>\n
55<\/span><\/td>\n-1<\/span><\/td>\n<\/tr>\n
Angela<\/span><\/td>\n0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
ii. IsText<\/span><\/h3>\n
We use the IsText() function to evaluate a script for text or string values. Just as the IsNum function returns -1 and 0 when it finds or does not find any numeric value respectively, the IsText function does for the text value.<\/span><\/p>\n
Let’s revise Qlik Sense Color Functions<\/a><\/strong><\/p>\n
The syntax for Qlik Sense IsText:<\/strong><\/p>\n
IsText(expression)<\/pre>\n
For instance, if we load the same data inline as we did in the example above and apply IsText() function on it, then the resultant table would be, <\/span><\/p>\n
Load *, IsText(Entries)\r\nInline [\r\nEntries\r\n23\r\nMike\r\nRobert\r\n40\r\n55\r\nAngela];<\/pre>\n
Here. The resultant table will have two fields or columns, Entries and IsText(Entries) where -1 shows yes, the corresponding value is a text or string and a 0 represents negative for encountering a string value.<\/p>\n\n\n\n\n\n\n\n\n\n
Entries<\/strong><\/td>\nIsText(Entries)<\/strong><\/td>\n<\/tr>\n
23<\/span><\/td>\n0<\/span><\/td>\n<\/tr>\n
Mike<\/span><\/td>\n-1<\/span><\/td>\n<\/tr>\n
Robert<\/span><\/td>\n-1<\/span><\/td>\n<\/tr>\n
40<\/span><\/td>\n0<\/span><\/td>\n<\/tr>\n
55<\/span><\/td>\n0<\/span><\/td>\n<\/tr>\n
Angela<\/span><\/td>\n-1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
So, this was all in Qlik Sense Logical Functions. Hope you like our explanation.<\/p>\n
3. Conclusion<\/span><\/h2>\n
Hence, in both of the IsNum and IsText functions a logical operation occurs which has only two outcomes i.e. a True (-1) and a False (0). These are easy to use as they are based on a very simple evaluation logic.<\/span><\/p>\n
Tell us about your experience of reading Qlik Sense Logical Functions through comments.<\/p>\n
See also –\u00a0<\/strong><\/p>\n
Qlik Sense Treemap Visualization<\/a><\/strong><\/p>\n
Reference for Qlik Sense<\/a><\/strong>
1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense Mathematical Functions. Today, we will see Qlik Sense Logical Functions. Moreover, we are going to study such functions which are used to...<\/p>\n","protected":false},"author":6,"featured_media":41723,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17610,17611,17609,17608],"class_list":["post-40326","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-isnum-function-in-qlik-sense","tag-istext-function-in-qlik-sens","tag-logical-functions-in-qlik-sense","tag-qlik-sense-logical-functions"],"yoast_head":"\nQlik Sense Logical Functions - IsNum and IsText - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Logical Functions, IsText Function in Qlik Sense, IsNum Logical Function in Qlik sense with syntax and example\" \/>\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-logical-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Logical Functions - IsNum and IsText - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Logical Functions, IsText Function in Qlik Sense, IsNum Logical Function in Qlik sense with syntax and example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-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:50:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Logical-Functions-01.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 Logical Functions - IsNum and IsText - DataFlair","description":"Qlik Sense Logical Functions, IsText Function in Qlik Sense, IsNum Logical Function in Qlik sense with syntax and example","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-logical-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Logical Functions - IsNum and IsText - DataFlair","og_description":"Qlik Sense Logical Functions, IsText Function in Qlik Sense, IsNum Logical Function in Qlik sense with syntax and example","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-09T10:50:49+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Logical-Functions-01.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-logical-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Logical Functions – IsNum and IsText","datePublished":"2018-11-09T10:50:49+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/"},"wordCount":585,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Logical-Functions-01.jpg","keywords":["IsNum Function in Qlik sense","IsText Function in Qlik Sens","Logical Functions in Qlik Sense","Qlik Sense Logical Functions"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/","name":"Qlik Sense Logical Functions - IsNum and IsText - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Logical-Functions-01.jpg","datePublished":"2018-11-09T10:50:49+00:00","description":"Qlik Sense Logical Functions, IsText Function in Qlik Sense, IsNum Logical Function in Qlik sense with syntax and example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Logical-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Logical-Functions-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Logical Functions - IsNum and IsText"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-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 Logical Functions – IsNum and IsText"}]},{"@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\/40326","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=40326"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40326\/revisions"}],"predecessor-version":[{"id":41724,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40326\/revisions\/41724"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/41723"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=40326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=40326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=40326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}