topic Re: Master Calendar Challenges in QlikView

Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 08:11:32 GMT

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?

Re: Master Calendar Challenges

Digvijay_Singh — Mon, 25 Jul 2016 08:28:18 GMT

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.

Re: Master Calendar Challenges

Gysbert_Wassenaar — Mon, 25 Jul 2016 08:31:59 GMT

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

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 08:38:50 GMT

stalwar1‌ digvijay‌

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.

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 08:43:20 GMT

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

PrashantSangle — Mon, 25 Jul 2016 08:50:33 GMT

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,

Re: Master Calendar Challenges

Gysbert_Wassenaar — Mon, 25 Jul 2016 08:52:12 GMT

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.

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 09:06:06 GMT

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

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 09:12:34 GMT

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

Re: Master Calendar Challenges

Gysbert_Wassenaar — Mon, 25 Jul 2016 09:15:57 GMT

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

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 09:21:01 GMT

gwassenaar‌

Thanks but can u send me a pdf/video to learn this function

I will be grateful if you use the attached file to do a timestamp# function demo for me.

Thank you

Re: Master Calendar Challenges

PrashantSangle — Mon, 25 Jul 2016 09:23:02 GMT

see Gysbert reply every function related date and time are available in help menu or press F1 and type function whichever you want search.

check it try it if still issue then we are there to help you.

Regards,

Re: Master Calendar Challenges

Gysbert_Wassenaar — Mon, 25 Jul 2016 09:26:15 GMT

If you're not even willing to look up a function in a help file then you're beyond help as far as I'm concerned. Try finding a job that is less demanding for you.

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 09:33:57 GMT

gwassenaar‌

That's kinda harsh.... I am currently reading on timestamp and look at previous posts on it.

I am committed to what I do that why I asked for help...

Please let's be patient with one another

When I done with my research, If I got any challenge, I will let you know.

Best Regards

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 09:46:21 GMT

I'm on it.. Thank you

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 11:03:17 GMT

gwassenaar‌ Hello sir, Still no luck yet..

Can you help me with Clues?

I'm running out of time.

Best Regards

Re: Master Calendar Challenges

akpofureenughwu — Mon, 25 Jul 2016 11:19:41 GMT

Hello sir, I got it

Using the script

Date(Floor(Timestamp#("CH#DOC#LAST CHANGED AT", 'DD.MM.YYYY hh:mm:ss')), 'MM/DD/YYYY') as Date,

I was able to manipulate the date from the timestamp, but I didn't use the master calendar techniques, I use the preceding load for the date variables.

I still need more pro tips on this subject...

Re: Master Calendar Challenges

PrashantSangle — Mon, 25 Jul 2016 11:22:59 GMT

Awesome man,

try little bit more. Read some more threads. You are almost close to your answer.

Regards,

Re: Master Calendar Challenges

akpofureenughwu — Tue, 26 Jul 2016 13:27:25 GMT

I got a unique challenge right now

I was putting my data from SQL, I got the desired date field results (Month, Quarter and so on)

But for this work, I need to put the data from excel sheet... (Same structure, same field with the SQL connection) but the date fields are missing.

Please see attached files for clarity!!

I can you help me with clues how I will debug it

Thank you

Re: Master Calendar Challenges

PrashantSangle — Wed, 27 Jul 2016 05:08:52 GMT

Hi,

Just make sure your [CH.DOC.LAST CHANGED AT] is in date format not in text.

try with date#() or timestamp#()

try like

Date(Floor(Timestamp#([CH.DOC.LAST CHANGED AT], 'DD.MM.YYYY hh.mm.ss')), 'MM/DD/YYYY') as Date,

Regards,