Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
akpofureenughwu
Contributor 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
Honored Contributor III

Re: Master Calendar Challenges

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.

MVP & Luminary
MVP & Luminary

Re: Master Calendar Challenges

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
Contributor III

Re: Master Calendar Challenges

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
Contributor III

Re: Master Calendar Challenges

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

Re: Master Calendar Challenges

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.
MVP & Luminary
MVP & Luminary

Re: Master Calendar Challenges

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
Contributor III

Re: Master Calendar Challenges

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
Contributor III

Re: Master Calendar Challenges

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

MVP & Luminary
MVP & Luminary

Re: Master Calendar Challenges

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