Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Master Calendar Challenges

Good day everyone

Usually I use Master Calendar to generate my date related fields like Quarter, Month and so on

I wanted to use a field that contains date as well as time (Please see attached file "Date,png")

I have issues when I use this field

Please find the attached files including the master calendar script I used.

How can I resolve it?

19 Replies
Digvijay_Singh

What is the granularity you are expecting a day, an hour since you included time as well now.

If no change in granularity and u want calendar at day level, you may think of having two date fields, one with time and another without time, second one you can use for your calendar and first one for other use you may have thought of.

Also please share sample data in case its possible.

Gysbert_Wassenaar

No idea, bur your variables vMinDate and vMaxDate don't have values. Check that your Temp table contains records after creating it.


talk is cheap, supply exceeds demand
akpofureenughwu
Creator III
Creator III
Author

stalwar1digvijay

Please find the attached file.

Granularity...  It can be a day or an hour even. !

I will be grateful if you can assist me on this.

akpofureenughwu
Creator III
Creator III
Author

gwassenaar‌ Thanks for your response

My temp table is ok. If I choose any other date field without time value, It will give me a good response but I want to use the change log date to generate those fields (quarter and so on)

Please find attached file for clarity

PrashantSangle

Hi,

As gysbert suggested your variable don't have any value and that what your attached image also told.

In Date2.png You see empty value for varMinDate and varMaxDate

similarly in Date3.png, error is Monthstart() required value and because of that you will get error.

check what value you get in varMinDate and varMaxDate.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Gysbert_Wassenaar

Your timestamp fields do not contain valid timestamps, but text values. You need to use the TimeStamp# function to turn the text values into real timestamps.


talk is cheap, supply exceeds demand
akpofureenughwu
Creator III
Creator III
Author

gwassenaar‌ Thank you for spotting that out.

Can u assist me on how I can use that timeStamp# function?

Can you use the data I attached earlier to make a demo on qvw for me?

I appreciate your response sir

akpofureenughwu
Creator III
Creator III
Author

dreamer4‌ Thank you for your response,

It's when I use the Change Doc at last ... I get this error..

If I use QA IMPTD DATE and other similar fields, I have no errors.

Check it out

Gysbert_Wassenaar

Please try to educate yourself as much as you can and look up the timestamp# function in the help file.


talk is cheap, supply exceeds demand