{"id":40206,"date":"2018-11-09T15:56:37","date_gmt":"2018-11-09T10:26:37","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=40206"},"modified":"2018-11-09T15:56:37","modified_gmt":"2018-11-09T10:26:37","slug":"qlik-sense-mapping-function","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/","title":{"rendered":"Qlik Sense Mapping Functions With Syntax"},"content":{"rendered":"

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

In our last Qlik Sense Tutorial<\/strong>, we discussed Qlik Sense Scatter Plot Visualizations<\/a><\/strong>. Today, we will see Qlik Sense Mapping Functions. Moreover, we will look at mapping functions with syntax. We use the mapping functions for managing and working with mapping tables. Usually, we use the mapping tables in BI tools such as QlikView and Qlik Sense to map or replace field values or field names at the time of script execution. Basically, there are two Qlik Sense Mapping Functions, which we use in data load script, ApplyMap() and MapSubstring() function.<\/span><\/p>\n

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

\"Qlik<\/a>

Qlik Sense Mapping Functions With Syntax<\/p><\/div>\n

Have a look at Qlik Sense Line Chart<\/a><\/strong><\/p>\n

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

Below are some Mapping Functions in Qlik Sense –<\/p>\n

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

We use this function to map or mirror the output of an expression, that evaluates during script execution, in a previously loaded table. <\/span><\/p>\n

The syntax of Qlik Sense ApplyMap() function.<\/span><\/p>\n

ApplyMap('map_name', expression [,default_mapping])<\/pre>\n
Where <\/span>map_name<\/span><\/i> is the name of the table from which we want to map the fields or field values into a new table. This table will read by mapping LOAD or Mapping SELECT statements prior to applying the ApplyMap function. <\/span><\/p>\n
The expression<\/span><\/i> is that piece of quote or a condition, evaluation of whose result we need to map.<\/span><\/p>\n
The <\/span>default_mapping<\/span><\/i> is a conditional parameter which specifies the value that we use when the table evaluates for the expression condition, does not contain a certain value. If the default mapping value is not set then the value of the expression will return as it is.<\/span><\/p>\n
Do you know about Qlik Sense Exponential and Logarithmic Functions<\/a><\/strong><\/p>\n
For instance, <\/span><\/p>\n
\/\/ Load mapping table of country codes:\r\nmap1:\r\nmapping LOAD *\r\nInline [\r\nCountryCode, Country\r\nSwd, Sweden\r\nDmk, Denmark\r\nNor, Norway\r\n] ;\r\nLOAD *,\r\nApplyMap( 'map1', CountryCode ) As Country\r\nInline [\r\nCountryCode, Salesperson\r\nSwd, John\r\nSwd, Mary\r\nSwd, Parker\r\nDmk, Josh\r\nDmk, Olivia\r\nNor, Emma\r\nNor, Fred\r\n] ;\r\n\/\/ We don't need the CountryCode anymore\r\nDrop Field 'CountryCode';<\/pre>\n
The resulting table is given below, where, using the ApplyMap() function the Country field is mapped using the CountryCode field in the expression. <\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n
Salesperson<\/b><\/td>\nCountry<\/b><\/td>\n<\/tr>\n
John<\/span><\/td>\nSweden<\/span><\/td>\n<\/tr>\n
Mary<\/span><\/td>\nSweden<\/span><\/td>\n<\/tr>\n
Parker<\/span><\/td>\nSweden<\/span><\/td>\n<\/tr>\n
Josh<\/span><\/td>\nDenmark<\/span><\/td>\n<\/tr>\n
Olivia<\/span><\/td>\nDenmark<\/span><\/td>\n<\/tr>\n
Emma<\/span><\/td>\nNorway<\/span><\/td>\n<\/tr>\n
Fred<\/span><\/td>\nNorway<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
ii. MapSubstring() function <\/span><\/h3>\n
The MapSubstring() function maps a substring or a part of a data field from a previously loaded data table (using mapping LOAD\/SELECT statements) to another table. This function is case-sensitive and returns a string type data value. <\/span><\/p>\n
The syntax of Qlik Sense MapSubstring() function<\/span>:<\/span><\/p>\n
MapSubstring('map_name', expression)<\/pre>\n
Where <\/span>map_name<\/span><\/i> is the name of previously loaded table using the mapping LOAD\/SELECT statement. <\/span><\/p>\n
Expression<\/span><\/i> is that statement whose result is to be mapped as substrings on the new table. <\/span><\/p>\n
For example, first load a table named \u2018attributes\u2019 having two fields, AttributeCode and the Attribute to which each code corresponds. Then in the next table, we will load a table named \u2018Productmodels\u2019 in which we will use the values of attribute table by applying MapSubstring function into the Productmodels table. In the resultant table, all the attribute names have been loaded in the Description table by just mapping the AttributeCode substring in the Productmodels function.<\/span><\/p>\n
Let’s revise Qlik Sense Color Functions<\/a><\/strong><\/p>\n
attributes:\r\nmapping LOAD *\r\nInline [\r\nAttributeCode, Attribute\r\nR, Red\r\nY, Yellow\r\nB, Blue\r\nC, Cotton\r\nP, Polyester\r\nS, Small\r\nM, Medium\r\nL, Large\r\n] ;\r\nProductmodels:\r\nLOAD *,\r\nMapSubString('attributes\u2019, AttributeCode) as Description\r\nInline [\r\nModel, AttributeCode\r\nTwixie, R C S\r\nBoomer, B P L\r\nRaven, Y P M\r\nSeedling, R C L\r\nSeedlingPlus, R C L with hood\r\nYounger, B C with patch\r\nMultiStripe, R Y B C S\/M\/L\r\n] ;\r\n\/\/ We don't need the AttributeCode anymore\r\nDrop Field 'AttributeCode';<\/pre>\n
Below, is the resultant table. Here, with the help of MapSubstring function, the respective attributes of the given models have been mapped in the field Description using AttributeCode field values. <\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n
Model<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Twixie<\/span><\/td>\nRed Cotton Small<\/span><\/td>\n<\/tr>\n
Boomer<\/span><\/td>\nBlue Polyester Large<\/span><\/td>\n<\/tr>\n
Raven<\/span><\/td>\nYellow Polyester Medium<\/span><\/td>\n<\/tr>\n
Seedling<\/span><\/td>\nRed Cotton Large<\/span><\/td>\n<\/tr>\n
SeedlingPlus<\/span><\/td>\nRed Cotton Large with hood<\/span><\/td>\n<\/tr>\n
Younger<\/span><\/td>\nBlue Cotton with patch<\/span><\/td>\n<\/tr>\n
MutliStripe<\/span><\/td>\nRed Yellow Blue Cotton Small\/Medium\/Large<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
So, this was all in Qlik Sense Mapping Functions. Hope you like our explanation.<\/p>\n
3. Conclusion <\/span><\/h2>\n
Hence, these were all the mapping functions used in Qlik Sense to map table fields or substrings from the field. Still, if you have any query regarding Qlik Sense Mapping Functions, ask in the comment tab.<\/span><\/p>\n
See also –<\/p>\n
Qlik Sense Treemap Visualization<\/a><\/strong><\/p>\n
Reference for Qlik Sense<\/strong><\/a>
1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense Scatter Plot Visualizations. Today, we will see Qlik Sense Mapping Functions. Moreover, we will look at mapping functions with syntax. We use...<\/p>\n","protected":false},"author":6,"featured_media":40215,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17583,17582,17584,17585,17581],"class_list":["post-40206","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-applymap-qlik-sense","tag-mapping-functions-in-qlik-sense","tag-qlik-sense-applymap-example","tag-qlik-sense-mapping-example","tag-qlik-sense-mapping-functions"],"yoast_head":"\nQlik Sense Mapping Functions With Syntax - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Mapping Functions, ApplyMap Function, MapSubstring Function in Qlik Sense with syntax,Qlik Sense Tutorial,qlik Sense applymap 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-mapping-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Mapping Functions With Syntax - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Mapping Functions, ApplyMap Function, MapSubstring Function in Qlik Sense with syntax,Qlik Sense Tutorial,qlik Sense applymap example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/\" \/>\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:26:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Mapping-Functions-vol.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=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Mapping Functions With Syntax - DataFlair","description":"Qlik Sense Mapping Functions, ApplyMap Function, MapSubstring Function in Qlik Sense with syntax,Qlik Sense Tutorial,qlik Sense applymap 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-mapping-function\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Mapping Functions With Syntax - DataFlair","og_description":"Qlik Sense Mapping Functions, ApplyMap Function, MapSubstring Function in Qlik Sense with syntax,Qlik Sense Tutorial,qlik Sense applymap example","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-09T10:26:37+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Mapping-Functions-vol.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Mapping Functions With Syntax","datePublished":"2018-11-09T10:26:37+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/"},"wordCount":622,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Mapping-Functions-vol.jpg","keywords":["Applymap Qlik Sense","Mapping Functions in Qlik Sense","Qlik Sense applymap example","Qlik Sense mapping example","Qlik Sense Mapping Functions"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/","name":"Qlik Sense Mapping Functions With Syntax - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Mapping-Functions-vol.jpg","datePublished":"2018-11-09T10:26:37+00:00","description":"Qlik Sense Mapping Functions, ApplyMap Function, MapSubstring Function in Qlik Sense with syntax,Qlik Sense Tutorial,qlik Sense applymap example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Mapping-Functions-vol.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Mapping-Functions-vol.jpg","width":1200,"height":628,"caption":"Qlik Sense Mapping Functions With Syntax"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/#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 Mapping Functions With Syntax"}]},{"@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\/40206","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=40206"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40206\/revisions"}],"predecessor-version":[{"id":41710,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40206\/revisions\/41710"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/40215"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=40206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=40206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=40206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}