{"id":39426,"date":"2018-11-06T14:16:48","date_gmt":"2018-11-06T08:46:48","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=39426"},"modified":"2018-11-04T17:31:21","modified_gmt":"2018-11-04T12:01:21","slug":"qlik-sense-conditional-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/","title":{"rendered":"Qlik Sense Conditional Functions – Syntax and Example"},"content":{"rendered":"

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

Today, we will see Qlik Sense Conditional Functions. Moreover, we will discuss syntax and example of Conditional Functions in Qlik Sense. Conditional functions evaluate an expression based on a specific condition and if that expression evaluates to be true for that condition then the action will be executed otherwise not.<\/span><\/p>\n

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

\"Qlik<\/a>

Qlik Sense Conditional Functions – Syntax and Example<\/p><\/div>\n

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

i. alt Function in Qlik Sense<\/span><\/h3>\n

The alt() function evaluates a condition for several (alternate) parameters one by one and if the condition matches none of the parameters or expressions then the last \u2018else\u2019 value is returned. There may any number of alternative parameters that we can add in the function\u2019s expressions.<\/span><\/p>\n

The syntax for alt function in Qlik Sense<\/strong><\/p>\n

alt(expr1[ , expr2 , expr3 , ...] , else)<\/pre>\n
Here, the expr1 will be the first expression to be evaluated, then of the condition for this expression returns false then the second expression, expr2 is evaluated for the given condition. This continues until the logic finds the expression match for the condition or for which the condition evaluates to be True. If none of the given parameters or expression matches the condition, then the expression\/value for \u2018else\u2019 is returned.<\/span><\/p>\n
For example,<\/strong><\/p>\n
alt( date#( dat , ‘YYYY\/MM\/DD’ ),<\/span><\/p>\n
date#( dat , ‘MM\/DD\/YYYY’ ),<\/span><\/p>\n
date#( dat , ‘MM\/DD\/YY’ ),<\/span><\/p>\n
‘No valid date’ )<\/span><\/p>\n
This expression has three parameters or possible expressions for the date format. If an entered data\u2019s format matches any of the three formats the condition will become True and the respective date will be displayed in the proper format. It will return a dual format value having both text and numeric interpretations to of the date. But if the entered date or value does not match these three date formats then \u2018No valid date\u2019 note will be returned which is the \u2018else\u2019 statement. <\/span><\/p>\n
ii. class Function in Qlik Sense<\/span><\/h3>\n
The class() function makes classes for data values or to put it in another way, it classifies and sorts the values entered by the users into certain classes defined by this function. This function takes a variable value evaluates it for the interval condition specified for that variable and puts it in that category or class. Let us say that there is a variable \u2018Percentage\u2019 and if the percentage = 74 then using the class function you can put this into a range or class of 70 to 80. <\/span><\/p>\n
The syntax for Qlik Sense class Function<\/strong><\/p>\n
class(expression, interval [ , label [ , offset ]])<\/pre>\n
This gives the result in a<=x<b<\/span><\/p>\n
Where <\/span>expression<\/span><\/i> is the variable or parameter that you define.<\/span><\/p>\n
Interval<\/span><\/i> is the range that defines the minimum and maximum values of a class, i.e. if you set the interval to be 10 then for every variable value the range will be set for 10 values like 30 to 40 for 34, if you set it 5 then 30 to 35 for variable 34 etc. <\/span><\/p>\n
The label<\/span><\/i> gives the variable which is generally represented as x a name. Like if x is representing the age of a person then you can set the label as \u2018age\u2019. <\/span><\/p>\n
An <\/span>offset<\/span><\/i> is a number that can be used as an offset or deviation from the default starting point of the classification. The default starting point is normally set at 0. You can specify the value by how much you want to make an offset from the default value like \u00a05,10 etc. <\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
We have a list of people with their ages. We want to classify these people based on their age groups, for which we will use the class() function. <\/span><\/p>\n
LOAD *,\r\nclass(Age, 10, 'age') As Agegroup;\r\nLOAD * INLINE\r\n[ Age, Name\r\n25, John\r\n42, Suzen\r\n53, Mark];<\/pre>\n
Now, this function will return, <\/span><\/p>\n\n\n\n\n\n\n
Name<\/b><\/td>\nAge<\/b><\/td>\nAge group<\/b><\/td>\n<\/tr>\n
John<\/span><\/td>\n25<\/span><\/td>\n20<= age <30<\/span><\/td>\n<\/tr>\n
Suzen<\/span><\/td>\n42<\/span><\/td>\n40<= age <50<\/span><\/td>\n<\/tr>\n
Mark<\/span><\/td>\n53<\/span><\/td>\n50<= age <60<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Where age is the label and each person is classified into age groups as defined in the class() function. The expression was Age, the interval was 10 and label was age.<\/span><\/p>\n
iii. If Function in Qlik Sense<\/span><\/h3>\n
The if() function evaluates an expression based on certain condition. If the expression evaluates to be True for that condition, then the \u2018then\u2019 value is return. But if it evaluates to be False then \u2018else\u2019 value is returned.<\/span><\/p>\n
The syntax for If Function in Qlik Sense<\/strong><\/p>\n
if(condition , then , else)<\/pre>\n
The condition is the <\/span>expression<\/span><\/i> which will be evaluated in the logic provided here. <\/span>Then<\/span><\/i> defines what is to be returned if the condition is true, whereas, <\/span>else<\/span><\/i> defines what will return if the condition is false. <\/span><\/p>\n
For example,<\/strong><\/p>\n
If( Batterypercent>=15, \u2018Charged\u2019, \u2018BatteryLow\u2019)<\/span><\/p>\n
This statement means that if the battery percent is greater than or equal to 15 then return \u2018Charged\u2019 but if it is less than 15 i.e. if the condition is false, then return \u2018BatteryLow\u2019. <\/span><\/p>\n
iv. match Function in Qlik Sense<\/span><\/h3>\n
Match function is used to carry out a case sensitive match. It matches the first expression with the following expressions and returns the number of expression or value that it matches. You can add n number of expressions from which you need to match the first expression.<\/span><\/p>\n
The syntax for match function in Qlik Sense<\/strong><\/p>\n
match( str, expr1 [ , expr2,...exprN ])<\/pre>\n
For example,<\/strong><\/p>\n
match( M, ‘Jan’,’Feb’,’Mar’,\u2019Apr\u2019)<\/span><\/p>\n
This will return 3 if M= Mar because Mar is the third value. And, it will return 0 is M was equals to May which is not in the search result options.<\/span><\/p>\n
v. mixmatch Function in Qlik Sense<\/span><\/h3>\n
This function performs the same operation as the match() function but it is case insensitive i.e. the case of the value or string you are searching for will not matter. If A= Apple or apple the logic will search it. <\/span><\/p>\n
The syntax for Qlik Sense mixmatch function<\/span>:<\/span><\/p>\n
mixmatch( str, expr1 [ , expr2,...exprN ])<\/pre>\n
For example,<\/strong><\/p>\n
if fav= Mango then the expression given below,<\/span><\/p>\n
mixmatch (fav, \u2018mango\u2019, \u2018apple\u2019, \u2018peach\u2019, \u2018strawberry\u2019)<\/span><\/p>\n
Will return the value 1 because it matches the value on the first number or position. <\/span><\/p>\n
vi. Wildmatch Function in Qlik Sense<\/span><\/h3>\n
Wildmatch function is also a value matching function like match() and mixmatch() but it uses wildcards (* ?) and is case insensitive in searching. The first expression that we search should match with the following possible search result expressions. If the first expression matches any of the following expressions, then the numeric value of their position in the list is returned.<\/span><\/p>\n
The syntax for Qlik Sense Wildmatch Function:<\/strong><\/p>\n
wildmatch( str, expr1 [ , expr2,...exprN ])<\/pre>\n
For example,<\/strong><\/p>\n
wildmatch( M, ‘ja*’,’fe?’,’mar’)<\/span><\/p>\n
It will return 1 of M= January and will also return 2 if M=Feb\/Fex\/Fen or anything. <\/span><\/p>\n
vii. pick Function in Qlik Sense<\/span><\/h3>\n
The pick() function picks a particular value from a specific location in the list of expressions. This function selects and returns the expression present on the n<\/span>th <\/span>position. <\/span><\/p>\n
The syntax for Qlik Sense pick Function:<\/strong><\/p>\n
pick(n, expr1[ , expr2,...exprN])<\/pre>\n
Where n is an integer between 1 and n.<\/span><\/p>\n
For example,<\/strong><\/p>\n
pick( 2, ‘Sam’,’Jones’, \u2018Nick\u2019, \u2018Joe\u2019 )<\/span><\/p>\n
This will return the second value i.e. Jones because of n=2.<\/span><\/p>\n
So, this was all in Qlik Sense Conditional Functions. Hope you like our explanation.<\/p>\n
3. Conclusion – Conditional Functions in Qlik Sense<\/span><\/h2>\n
Hence, in this Qlik Sense Conditional Functions tutorial, we discussed conditional Functions in Qlik Sense such as alt, class, if, match etc. Also, we saw syntax and example of each Qlik Sense Conditional Functions. All these Conditional Functions used in the data load script and charts of Qlik Sense.<\/span><\/p>\n
Still, if you have any query regarding Qlik Sense Conditional Functions, ask in the comment tab.<\/p>\n
Reference for Qlik Sense<\/strong><\/a>
1. Objective Today, we will see Qlik Sense Conditional Functions. Moreover, we will discuss syntax and example of Conditional Functions in Qlik Sense. Conditional functions evaluate an expression based on a specific condition and...<\/p>\n","protected":false},"author":6,"featured_media":39430,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17540,17541,17538,17542,17544,17539,17543],"class_list":["post-39426","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-alt-functions-in-qlik-sense","tag-class-function-in-qlik-sense","tag-conditional-functions-in-qlik-sense","tag-if-function-in-qlik-sense","tag-pick-function-in-qlik-sense","tag-qlik-sense-conditional-functions","tag-wildmatch-in-qlik-sense"],"yoast_head":"\nQlik Sense Conditional Functions - Syntax and Example - DataFlair<\/title>\n<meta name=\"description\" content=\"Conditional Functions in Qlik Sense,alt function,class function,if function,wildmatch fuction,pick function,mixmatch function,conditional Functions 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-conditional-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Conditional Functions - Syntax and Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Conditional Functions in Qlik Sense,alt function,class function,if function,wildmatch fuction,pick function,mixmatch function,conditional Functions example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-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-06T08:46:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Conditional-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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Conditional Functions - Syntax and Example - DataFlair","description":"Conditional Functions in Qlik Sense,alt function,class function,if function,wildmatch fuction,pick function,mixmatch function,conditional Functions 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-conditional-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Conditional Functions - Syntax and Example - DataFlair","og_description":"Conditional Functions in Qlik Sense,alt function,class function,if function,wildmatch fuction,pick function,mixmatch function,conditional Functions example","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-06T08:46:48+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Conditional-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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Conditional Functions – Syntax and Example","datePublished":"2018-11-06T08:46:48+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/"},"wordCount":1219,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Conditional-Functions-01.jpg","keywords":["alt functions in Qlik Sense","class function in Qlik Sense","Conditional Functions in Qlik Sense","If function in Qlik Sense","pick Function in Qlik Sense","Qlik Sense Conditional Functions","Wildmatch in Qlik Sense"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/","name":"Qlik Sense Conditional Functions - Syntax and Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Conditional-Functions-01.jpg","datePublished":"2018-11-06T08:46:48+00:00","description":"Conditional Functions in Qlik Sense,alt function,class function,if function,wildmatch fuction,pick function,mixmatch function,conditional Functions example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Conditional-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Conditional-Functions-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Conditional Functions - Syntax and Example"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-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 Conditional Functions – Syntax and Example"}]},{"@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\/39426","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=39426"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39426\/revisions"}],"predecessor-version":[{"id":39431,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39426\/revisions\/39431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/39430"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=39426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=39426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=39426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}