Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sumit2504
Contributor III
Contributor III
‎2021-12-21 09:42 PM

Create a dummy calendar dates to link it with master calendar

Hi All,

I have a table A which doesn't have date fields and I have created a master calendar from another table B.

How to create a dummy dates for Table A so it can be linked with Master calendar.?

 

Regards,

Sumit

887 Views
0 Likes
2 Replies
anat
Master
Master
‎2021-12-21 11:19 PM

Creating dummy dates is based on your business requirement, but any how u can use today() function to create date field. 

839 Views
0 Likes
Sumit2504
Contributor III
Contributor III
‎2021-12-21 11:29 PM
Author

In response to anat

@anat Thanks for your response, today() will display only today's date. Is there any way where i can store today() in QVD's and after every day it'll generate QVD's which contain old dates too.

Eg - today() 22/12/2021 and it'll reload daily will generate 23/12, 24/12 and same dates i can use in my application

If you've any code please share it with me

 

Regards,

Sumit

815 Views
0 Likes