{"id":29058,"date":"2018-09-29T18:00:30","date_gmt":"2018-09-29T12:30:30","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=27603"},"modified":"2021-12-07T11:24:14","modified_gmt":"2021-12-07T05:54:14","slug":"qlikview-keep-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/","title":{"rendered":"QlikView Keep Functions – Left, Right, Inner Keep Function"},"content":{"rendered":"

After understanding the QlikView Join functions<\/strong><\/a>, let us move further and learn about another function called QlikView Keep Function. Moreover, we will discuss the types of Keep functions in QlikView: left, right, inner functions with the example.<\/span><\/span><\/p>\n

So, let us explore the Keep function with example.<\/span><\/span><\/p>\n

\"QlikView<\/a>

QlikView Keep Functions – Left, Right, Inner Keep Function in QlikView<\/p><\/div>\n

What is QlikView Keep Function?<\/h3>\n

The QlikView Keep Function<\/em> is used to merge two or more data sets together into one keeping the original data files intact in memory. Here it differs from Join as when you apply the join function to combine two data sets, the software loads and creates a single combined data set as a result. It does not retain the original files as it is in the memory which the Keep function does. <\/span><\/span><\/p>\n

Even after applying QlikView Keep function in the data files, you get the option whether you want to choose fields from the old tables or the new combined one. So in a way, the keep function is not practically joining the data sets but is just reducing repetitive data load from the data sets by keeping them in the memory as the same field value. <\/span><\/span><\/p>\n

So as to avoid unnecessary explicit or clear data combining and leaving some room for manipulation and making the merging of data sets a little flexible.<\/span><\/span><\/p>\n

Do you know How to Create\u00a0QlikView Dashboard?<\/a><\/strong><\/p>\n

We will be illustrating QlikView Keep Function through sample data files in the upcoming section. One more evident difference between Keep and Join is that join has an OUTER type of join where you get to join and see two or more tables into one full table. Such an Outer type is not available in Keep.<\/span><\/span><\/p>\n

Types of Keep Function in QlikView<\/h3>\n

We have explained three different kinds of QlikView Keep Function using two data sets given below.<\/span><\/span><\/p>\n

QlikView Keep Functions Example<\/strong><\/p>\n

Table1:-<\/span><\/strong><\/span><\/p>\n

Product_Id,Product_Type,Product_name<\/span><\/p>\n

pr5,Health & Beauty,Body Lotion<\/span><\/p>\n

pr6,Arts & Entertainment,Musical Instruments<\/span><\/p>\n

pr7, Arts & Entertainment, Orchestra Accessories<\/span><\/p>\n

pr8,Arts & Entertainment,Crafting Materials<\/span><\/p>\n

pr9, Hardware, Power Tool Batteries<\/span><\/p>\n

pr10,Home & Garden,Bath Caddies<\/span><\/p>\n

pr11,”Food, Beverages & Tobacco”,Frozen Vegetables<\/span><\/p>\n

pr12,Home & Garden,Power Equipment<\/span><\/p>\n

pr13, Home & Garden, Water Hose<\/span><\/p>\n

pr14, Health & Beauty,\u00a0Aloe vera Gel<\/span><\/p>\n

pr15,Health & Beauty,Face pack<\/span><\/p>\n

Let’s revise the Architecture of QlikView<\/span><\/a><\/strong><\/span><\/p>\n

Table2:<\/span><\/strong><\/span><\/p>\n

Product_Id,Product_Type<\/span><\/p>\n

pr1,Sporting Goods<\/span><\/p>\n

pr2,”Food, Beverages & Tobacco”<\/span><\/p>\n

pr3,Apparel & Accessories<\/span><\/p>\n

pr4,Sporting Goods<\/span><\/p>\n

pr5,Health & Beauty<\/span><\/p>\n

pr6,Arts & Entertainment<\/span><\/p>\n

pr7,Arts & Entertainment<\/span><\/p>\n

pr8,Arts & Entertainment<\/span><\/p>\n

These files were loaded into QlikView script (opened by CTRL+E) where we will add the Keep function between two LOAD commands.<\/span><\/span><\/p>\n

a. QlikView Inner Keep<\/h4>\n

Inner Keep function in QlikView, is the same as the Inner Join function as it fetches the common data values between the two tables (Left and Right table).<\/span><\/span><\/p>\n

Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nINNER KEEP(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Keep Functions –\u00a0QlikView Inner Keep<\/p><\/div>\n
Although, when you load the files into the script, save and reload it, you get an option to choose which table do you want to select fields from while creating the Table Box or any sheet object for that matter.<\/span><\/span><\/p>\n
Let’s Read about QlikView Table (Creating Cross, Straight, Pivot, Mapping Tables)<\/a><\/strong><\/p>\n
\"QlikView<\/a>
QlikView Keep Functions –\u00a0QlikView Inner Keep<\/p><\/div>\n
In the screenshot given above, the tab \u2018Show Fields From Table\u2019 has all the three kinds (two original and one combined) of table loaded. The current selection made here is the \u2018Product List\u2019 table and as you can see in the \u2018Fields Displayed\u2019 box, only the fields present in Product List table are available for selection.<\/span><\/span><\/p>\n
\"QlikView<\/a>
QlikView Keep Functions –\u00a0QlikView Inner Keep<\/p><\/div>\n
This time we have changed the selection and have another original table \u2018Name\u2019 that has the product name field added. The display box shows two key fields and one added field Product_name also.<\/span><\/span><\/p>\n
\"QlikView<\/a>
QlikView Keep Functions-\u00a0QlikView Inner Keep<\/p><\/div>\n
Now, to see the merged table, we have selected \u2018All Tables\u2019 option which shows the field from all the tables present in QlikView\u2019s memory. This will be the table created from the function KEEP.<\/span><\/span><\/p>\n
Also, See – Features of QlikView Script Editor<\/a><\/strong><\/p>\n
\"QlikView<\/a>
QlikView Keep Functions-\u00a0QlikView Inner Keep<\/p><\/div>\n
These are separate table boxes created by being able to choose fields. from individual data files. Here, the inner keep takes only the data values (ID 5 to 8) that were common in both data sets.<\/span><\/span><\/p>\n
b. QlikView Left Keep<\/h4>\n
The Left Keep fetches all the data values from the left table (Productname)<\/strong> and only the common values from the right table.<\/span><\/span><\/p>\n
Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nLEFT KEEP(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Keep Functions-\u00a0QlikView Left Keep<\/p><\/div>\n
\"QlikView<\/a>
QlikView Keep Functions-\u00a0QlikView Left Keep<\/p><\/div>\n
c. QlikView Right Keep<\/h4>\n
The Right keep, on the contrary, fetches all the values from the right table (Product List) and the common values from the left table.<\/span><\/span><\/p>\n
Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nRIGHT KEEP(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Keep Functions-\u00a0QlikView Right Keep<\/p><\/div>\n
Do you know how to Generate Data in QlikView?<\/a><\/strong><\/p>\n
\"QlikView<\/a>
QlikView Keep Functions-\u00a0QlikView Right Keep<\/p><\/div>\n
So, this was all about QlikView Keep Function. Hope you like our explanation.<\/p>\n
Conclusion<\/h3>\n
Hence, QlikView Keep function is beneficial as it provides the original table as well as the combined in the memory for users to create table as per their convenience. It eliminates data redundancy as well. Still, have a confusion, share your query with us!<\/span><\/span><\/p>\n
Related Topic –\u00a0QlikView Dimensions and Measures<\/a><\/strong><\/p>\n
For reference\u00a0<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
After understanding the QlikView Join functions, let us move further and learn about another function called QlikView Keep Function. Moreover, we will discuss the types of Keep functions in QlikView: left, right, inner functions...<\/p>\n","protected":false},"author":6,"featured_media":37006,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[11002,11017,11018,11020,11052,15077,15881],"class_list":["post-29058","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-qlikview-inner-keep","tag-qlikview-keep-functions-example","tag-qlikview-keep-functions-tutorial","tag-qlikview-left-keep","tag-qlikview-right-keep","tag-types-of-keep-functions-in-qlikview","tag-what-is-qlikview-keep-functions"],"yoast_head":"\nQlikView Keep Functions - Left, Right, Inner Keep Function - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Keep Functions tutorial- Types of Keep Function: QlikView Inner, Right and Left with examples with csv files of problesm with their solutions\" \/>\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\/qlikview-keep-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Keep Functions - Left, Right, Inner Keep Function - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Keep Functions tutorial- Types of Keep Function: QlikView Inner, Right and Left with examples with csv files of problesm with their solutions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-keep-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-09-29T12:30:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:54:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Keep-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=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Keep Functions - Left, Right, Inner Keep Function - DataFlair","description":"QlikView Keep Functions tutorial- Types of Keep Function: QlikView Inner, Right and Left with examples with csv files of problesm with their solutions","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\/qlikview-keep-functions\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Keep Functions - Left, Right, Inner Keep Function - DataFlair","og_description":"QlikView Keep Functions tutorial- Types of Keep Function: QlikView Inner, Right and Left with examples with csv files of problesm with their solutions","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-09-29T12:30:30+00:00","article_modified_time":"2021-12-07T05:54:14+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Keep-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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Keep Functions – Left, Right, Inner Keep Function","datePublished":"2018-09-29T12:30:30+00:00","dateModified":"2021-12-07T05:54:14+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/"},"wordCount":972,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Keep-Functions-01.jpg","keywords":["QlikView Inner Keep","QlikView Keep Functions Example","QlikView Keep Functions Tutorial","QlikView Left Keep","QlikView RIght Keep","Types of Keep Functions in QlikView","What is QlikView Keep Functions"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/","name":"QlikView Keep Functions - Left, Right, Inner Keep Function - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Keep-Functions-01.jpg","datePublished":"2018-09-29T12:30:30+00:00","dateModified":"2021-12-07T05:54:14+00:00","description":"QlikView Keep Functions tutorial- Types of Keep Function: QlikView Inner, Right and Left with examples with csv files of problesm with their solutions","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Keep-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Keep-Functions-01.jpg","width":1200,"height":628,"caption":"QlikView Keep Functions - Left, Right, Inner Keep Function in QlikView"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Keep Functions – Left, Right, Inner Keep Function"}]},{"@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\/29058","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=29058"}],"version-history":[{"count":12,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/29058\/revisions"}],"predecessor-version":[{"id":105181,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/29058\/revisions\/105181"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/37006"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=29058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=29058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=29058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}