Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
- Qlik Community
- :
- All Forums
- :
- Search
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
3,724 results
Sorted by:
2011-12-13
06:53 AM
Hi I have several QVDs with date fields (Year and Month). In other to avoid a loop, I have decided to use a master calendar but its still not working properly (the dates are not joinning) - e.g....
Labels
- Subscribe by Topic:
-
QlikView App Dev
2018-08-20
11:07 AM
2 Likes
Hi All, I am new to Qlikview How to Create Master Calendar ? Please Help.
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
Hi Jones, Master Calendar table is generally created to provide additional date fields like Q...
-
Hi, refer this link Master Calendar Generation Script Thanks, Pooja
-
Hi Jones, Master calendar is a table in a QlikView/Qlik Sense data model which generally c...
-
Hi Jones, There are a lot of posts and blogs talking about "Master Calendar", doing a simple s...
-
This too: Master Calendar for Fiscal Year starting April
-
...odifications on Master calendar scripting.
-
How to create a master calendar and link it if I have two tables? One is the Order table which c...
-
...he invoice table I extract the year from gl_date. Now I want to create a master calendar by linking t...
-
...reating master calendar & Extract all the necessary date columns required for the dashboards between m...
2016-07-28
05:01 PM
2 Likes
...s the autogenerate date range script for Master calendar: TempCalendar: LOAD Date($(vStartDate) + RecNo()) as TempDate autogenerate $(vEndDate) - $(vStartDate); MasterCalendar: Load T...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (4)
-
...nd Date based on a master calendar; (completed but only apply for Case_Receive tab) 3. Assigned s...Master Calendar Example.qvw (169 KB)
-
...nd Master Calendar? If I need to create at least two of them, such as DateLink and Master Calendar...
-
...ate fields through a master calendar. You can find the sample QVW attachment from above post....
-
...likviewcookbook.com/recipes/download-info/enter-date-from-to/ -Rob http://masterssummit.com h...
2023-06-29
09:19 AM
1 Like
I have 2 dates fields Reported Date and Incident date. I have created 2 master calendars one for each of the date fields. I want to create a table to see how many incidents occurred based on 'I...
Labels
- Subscribe by Topic:
-
Other
-
QlikView App Dev
2015-04-01
01:30 PM
11 Likes
Hi Qlikers, I have a question related to the actual benefit of having a Master Calendar. The discussion came about because one of my colleague recently created a Master Calendar not based on d...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
...ure that you'll never use date as dimension in charts, you have nothing to loose using Master Calendar....
-
Great question...I wonder the same thing whenever I create master calendar. In fact when we don't c...
-
Thanks Manish for sharing your valuable suggestions on the master calendar.
-
...rankfurt and discussed this topic with swr. In short, the result was that the use from a master-calendar...
-
...ppreciate you listing out advantages of having a master calendar and I am almost tempted to mark your a...
-
...reating/use of Master Calendar. To create and use Master Calendar is completely depends on what type o...
-
...ense because Fact table could have millions of rows of data vs Master Calendar which would be only 10's o...
-
...ithin the fact-table or you linked it per master-calendar. But these fields needs within large fact-t...
-
I put some of my thoughts on Master Calendar in this post: http://www.quickintelligence.co.uk/q...
2015-12-30
05:09 AM
Hi Experts, Can someone help me how to create Master calendar for the attached data Thanks in Advance
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (5)
-
Master Calendar in QlikView | Learn QlikView Master Calendar Generation Script
-
Dear Jack, Kindly find attached Master Calendar. Kind regards, Ishfaque Ahmed
-
Please see Creating A Master Calendar
-
Hi, Check this link tooo Master Calendar Generation Script Regards, Jagan.
-
Hi, another calendar script: tabCalendar: LOAD *, Day(Date) as D...
2012-10-24
10:55 AM
1 Like
Hi, I have some problems creating a Master Calendar with the right connections to the other tables without creating a syntetic key or a loop. This is what I have: Table 1 - Transactions t...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2018-09-05
07:00 AM
Hi Experts, Here I am attaching my qvd and qvw files, Can you guys please help me out for the below mentioned challenge: I have a multiple date columns in my file. Now i want to create master h...
- Tags:
- @master calendar
- calendar format
- calendar measures
- calendar&working days
- link_master_calender_to_the_existing_tables
- linking_to_master_calendar
- master calendar linking problem
- master calendar script
- master data calendar
- new to qlikview
- new_to_qlikview
- on qlik
- qlik search
- qlik sense and qlik view
- qlikvieew
- qlikview master calendar - multiple dates
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (4)
-
...ingh'}>}CandidateID) and this will relationship with master calendar and offer date column T...
-
...inking with master calendar
-
Hi priyalvp24, How to link with master calendar, Can you Please Explain me. If possible c...
-
Use this =Count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},plcda...
2010-08-17
04:23 AM
Hey guys I got a small problem. How do I add a master calendar into my document? In the document, I've got many different dates such as DueDate,ShipDate,StartDate,EndDate, etc. All of the data n...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
...nit_Date= Date('01/01/2000', 'DD/MM/YYYY'); Set Final_Date = Date('31/12/2010', 'DD/MM/YYYY'); Calendar...
-
Have you tried using the variables like file attached does? Check out your enviroment variables: ...
-
Its not working
-
Hey Keller Thanks for the response ill try it and get back to you
-
...pplication for selection purposes you need to include more calendar tables. So in your example you w...
-
Hey Ravi Thanks for the reply, but I have a small problem. I got many dates for different inform...
-
Please find the attached QV document. Regards, Ravi
-
anyone?
-
Sorry but the Data needs to be added into the script so if create list boxes, than the Fiscal year ...
2017-07-19
07:01 AM
Hi can someone upload an example script for a master calendar with Date and Time PLEASE I am trying to use the following script: But I am getting an error a: Load ID, &n...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (5)
-
Check this out Master Calendar with Hours, Minutes & Seconds But I suggest an a...
-
...ables? can you upload an example Yes, Master Calendar and Master Time. Unfortunately, I c...
-
Hi Sunny, is the Master Calendar with Hours, Minutes & Seconds article somehow r...
-
I am only seeing a single master calendar in your app... I guess based on the selections you have i...
-
Check the attached