{"id":29060,"date":"2018-09-29T17:57:52","date_gmt":"2018-09-29T12:27:52","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=27610"},"modified":"2021-12-07T11:24:17","modified_gmt":"2021-12-07T05:54:17","slug":"qlikview-master-calendar","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/","title":{"rendered":"QlikView Master Calendar – Creating with Example in Just 5 Steps"},"content":{"rendered":"

After completing QlikView Keep Function<\/a>,<\/strong> let’s move towards the QlikView Master Calendar Tutorial. Here, we will learn how to create Master Calendar in QlikView with an example.\u00a0As QlikView is known for it’s user-friendly and convenient operating, one such feature of QlikView is a Master Calendar.<\/p>\n

So, let’s start the QlikView Master Calendar Tutorial.<\/p>\n

What is QlikView Master Calendar?<\/h3>\n

Time plays an important role in data analysis. Whenever you are analyzing a data set having data generated over a period of time. You would want to have better insight into the details of time like which year? What month? Which quarter etc. <\/span><\/span><\/p>\n

But usually when data is generated<\/strong><\/a>, or entries are made the time and date are recorded in a fixed format like DD\/MM\/YYYY, and no information of week, weekday, quarter etc, is provided for analysis.<\/span><\/span><\/p>\n

QlikView Master Calendar is created to counter this issue. A Master Calendar created through QlikView script<\/strong><\/a> and can link to any of the databases present in QlikView<\/strong>.<\/a> Whenever a database contains entry fields having time or date, creating a Master Calendar in QlikView and linking it with that particular database or fact table will give you all the details of time and date.<\/span><\/span><\/p>\n

How to Create Master Calendar in QlikView?<\/h3>\n

Let us learn how to create QlikView Master Calendar and join it with the fact table containing a date field. The sample data that we have taken is a sales record (CSV file), which contains sales information like Order ID, Order date, Item name, and Sales value. We will create and link a QlikView master calendar with the OrderDate field. <\/span><\/span><\/p>\n

Input Data<\/span><\/strong><\/span><\/p>\n

Sales-<\/span><\/strong><\/span><\/p>\n

Order ID,OrderDate,Item,Sales<\/span><\/p>\n

1,08\/01\/2018,Bookcases,261<\/span><\/p>\n

2,10\/01\/2018,Chairs,735<\/span><\/p>\n

3,11\/01\/2018,Labels,146<\/span><\/p>\n

4,19\/01\/2018,Tables,1500<\/span><\/p>\n

5,20\/01\/2018,Storage,226<\/span><\/p>\n

6,25\/01\/2018,Furnishings,2486<\/span><\/p>\n

7, 27\/01\/2018,Art,728<\/span><\/p>\n

8,30\/01\/2018,Phones,9052<\/span><\/p>\n

9,02\/02\/2018,Binders,185<\/span><\/p>\n

10,04\/02\/2018,Bookcases,1149<\/span><\/p>\n

Firstly, we will select the above-delimited file from the INSERT option in the script editor (CTRL+E) and load it into QlikView\u2019s memory and save the loaded script.\u00a0<\/span><\/span><\/p>\n

Sales:\r\nLOAD [Order ID],\r\n     OrderDate,\r\n     Item, \r\n     Sales\r\nFROM\r\n[C:\\Users\\admin\\Documents\\Sales .csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n<\/pre>\n
\"How<\/a>
Step.1 To Create QlikView Master Calendar<\/p><\/div>\n
This is a simple dataset without the master calendar QlikView can create. As you can see, upon creating a table box using the above data file we get the date field displayed normally without any additional data fields for time and date.\u00a0<\/span><\/span><\/p>\n
\"How<\/a>
Step.2 To Create QlikView Master Calendar<\/p><\/div>\n
Now, we will add more fields related to date by creating and adding a master calendar in the same script.\u00a0<\/span><\/span><\/p>\n
Do you know What is QlikView Join Functions?<\/a><\/strong><\/p>\n
Sales:\r\nLOAD [Order ID],\r\n     DATE (DATE# (OrderDate,'D\/M\/YYYY')) AS OrderDate,\r\n     Item,\r\n     Sales,\r\nFROM\r\n[C:\\Users\\admin\\Documents\\Sales.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\n\r\nLOAD\r\n    Date(OrderDate) as OrderDate,\r\n    Year(OrderDate) as Year,\r\n    Month(OrderDate) as Month,\r\n    Day(OrderDate) as Day,\r\n    Week(OrderDate) as Week;\r\n\r\nLOAD \r\nDate(MinDate=IterNO ()-1) as OrderDate\r\nWhile(MinDate=IterNO ()-1) as <= Num(MaxDate);\r\n\r\nLOAD\r\n   Min(Date(Date# (OrderDate, 'D\/M\/YYYY'))) As MinDate,\r\n   Max(Date(Date# (OrderDate, 'D\/M\/YYYY'))) As MaxDate\r\nResident Sales ;<\/pre>\n
\"How<\/a>
Step.3 To Create QlikView Master Calendar<\/p><\/div>\n
In the script, we have used the load statement several times. The first load statement is to load the main fact table \u2018Sales\u2019. The second load statement use\u00a0for load the master calendar and the two load statements use after that to set a range of dates to start from and end it.<\/span><\/span><\/p>\n
If we would have only loaded the calendar without setting a minimum and maximum dates range. The calendar details for only the entered dates would have been shown. That is, QlikView Master Calendar for only the ten dates available in the data field would have been created. But if we also want the dates between the mentioned values, we have to write a code that sets a range of dates to fetch. <\/span><\/span><\/p>\n
So, we take a min date and max-date which will the entry of the first date in the table and the entry of the last date. The master calendar then will show all the dates and related details from the start to end or min to a max asset in the condition. The table link with the master calendar via resident load. <\/span><\/span><\/p>\n
Once you have created the script, saved(CTRL+S) and reloaded (CTRL+R). The script then creates a table box to see the date and time columns added by the master calendar. The new fields will also available in the field’s options given in the table box, add all these new fields like Day, Week, Month, Year and click OK.\u00a0<\/span><\/span><\/p>\n
\"Create<\/a>
Step.4 To Create QlikView Master Calendar<\/p><\/div>\n
The table box created will have all the new columns created by the master calendar as you can see in the screenshot given below. The table displays dates from 8\/01\/2018 till 4\/02\/2018 as per the range we have selected.<\/span><\/span><\/p>\n
Let’s explore the QlikView System Requirements for Version 11 & 12<\/a><\/strong><\/p>\n
\"Create<\/a>
Step.5 To Create QlikView Master Calendar<\/p><\/div>\n
You can also add a code line in the QlikView Master Calendar code if you wish to add a column displaying the Quarter of the year a particular date comes in. <\/span><\/span><\/p>\n
Code-<\/span><\/strong><\/span><\/p>\n
\u2018Q\u2019 &Ceil(Month(Nameofthedatefield) \/ 3) AS Quarter,<\/pre>\n
So, this was all about\u00a0QlikView Master Calendar Tutorial. Hope you like our explanation.<\/p>\n
Conclusion<\/h3>\n
Hence, we studied steps to create QlikView Master Calendar. In addition, we discussed u<\/span><\/span>sing the master calendar in QlikView, we can very easily add important date and time aspects into a dataset table through which analysis of that data with respect to time or a defined time period becomes very convenient. Is this Information helpful to you? Share your feedback with us!<\/span><\/span><\/p>\n
Related Topic –\u00a0QlikView Installation<\/a><\/strong><\/p>\n
For reference<\/a><\/strong><\/p>\n
After completing QlikView Keep Function, let’s move towards the QlikView Master Calendar Tutorial. Here, we will learn how to create Master Calendar in QlikView with an example.\u00a0As QlikView is known for it’s user-friendly and...<\/p>\n","protected":false},"author":6,"featured_media":36993,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[4094,10974,11031,11032,11033,11034,11036,11037,15882],"class_list":["post-29060","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-dynamic-calendar-in-qlikview","tag-qlikview-calendar-object","tag-qlikview-master-calendar-code","tag-qlikview-master-calendar-exmaple","tag-qlikview-master-calendar-fiscal-year","tag-qlikview-master-calendar-link","tag-qlikview-master-calendar-tutorial","tag-qlikview-master-calendar-with-time","tag-what-is-qlikview-master-calendar"],"yoast_head":"\nQlikView Master Calendar - Creating with Example in Just 5 Steps - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Master Calendar Tutorial- Steps to Create Master Calendar in QlikView, Example of Master Calendar, What is Master Calender\" \/>\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-master-calendar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Master Calendar - Creating with Example in Just 5 Steps - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Master Calendar Tutorial- Steps to Create Master Calendar in QlikView, Example of Master Calendar, What is Master Calender\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/\" \/>\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:27:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:54:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Master-Calendar-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":"QlikView Master Calendar - Creating with Example in Just 5 Steps - DataFlair","description":"QlikView Master Calendar Tutorial- Steps to Create Master Calendar in QlikView, Example of Master Calendar, What is Master Calender","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-master-calendar\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Master Calendar - Creating with Example in Just 5 Steps - DataFlair","og_description":"QlikView Master Calendar Tutorial- Steps to Create Master Calendar in QlikView, Example of Master Calendar, What is Master Calender","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-09-29T12:27:52+00:00","article_modified_time":"2021-12-07T05:54:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Master-Calendar-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\/qlikview-master-calendar\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Master Calendar – Creating with Example in Just 5 Steps","datePublished":"2018-09-29T12:27:52+00:00","dateModified":"2021-12-07T05:54:17+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/"},"wordCount":875,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Master-Calendar-01.jpg","keywords":["dynamic calendar in qlikview","qlikview calendar object","QlikView Master Calendar code","QlikView Master Calendar exmaple","qlikview master calendar fiscal year","qlikview master calendar link","QlikView Master Calendar Tutorial","qlikview master calendar with time","WHat is QlikView Master Calendar"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/","name":"QlikView Master Calendar - Creating with Example in Just 5 Steps - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Master-Calendar-01.jpg","datePublished":"2018-09-29T12:27:52+00:00","dateModified":"2021-12-07T05:54:17+00:00","description":"QlikView Master Calendar Tutorial- Steps to Create Master Calendar in QlikView, Example of Master Calendar, What is Master Calender","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Master-Calendar-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Master-Calendar-01.jpg","width":1200,"height":628,"caption":"How to Create QlikView Master Calendar?"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/#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 Master Calendar – Creating with Example in Just 5 Steps"}]},{"@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\/29060","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=29060"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/29060\/revisions"}],"predecessor-version":[{"id":105185,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/29060\/revisions\/105185"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/36993"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=29060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=29060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=29060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}