topic Re: Re: linking dates problem in QlikView

linking dates problem

Thu, 27 Feb 2014 19:25:57 GMT

Hello,

i'm trying to develop a calendar like this oneLinking to two or more dates

but i can't understand why my data doesn't apply the month correctly, it gets null on the feb month,

in this dataset contains the process, create date, completed date and status. I'm following the steps in the link but i can't understand what is wrong.

Please see the attached file.

Re: linking dates problem

whiteline — Thu, 27 Feb 2014 19:32:32 GMT

Hi.

You don't have any records for Feb dates in your DateLink table.

You should have all kinds of dates there, not only create Dates.

Concatenate the rest ones.

Re: linking dates problem

Thu, 27 Feb 2014 19:40:38 GMT

As you can see in the link tab i do have the COMPLETED_CALENDAR and the CREATE_CALENDAR concatenated to build the DateLink, and there are feb records. I'm i doing it wrong?

Re: linking dates problem

Anonymous — Thu, 27 Feb 2014 19:41:00 GMT

Something's wrong with the calendar. You have each date multiple times, and most of the dates are not associated with months and years.

Try to create table box with calendar fields, you'll see.

Re: linking dates problem

Thu, 27 Feb 2014 19:45:11 GMT

i know, and don't know caused this

Re: linking dates problem

Gysbert_Wassenaar — Thu, 27 Feb 2014 19:47:01 GMT

Something is wrong with the subroutine you use to create the calendar. Try this instead on your last script tab:

DROP TABLE TMP;

//CALL CalendarFromField('Date', 'CommonCalendar', '');

Calendar:

Load Date, Year(Date) as Year, Month(Date) as Month, day(Date) as Day, weekday(Date) as Weekday

resident DateLink;

Re: linking dates problem

Thu, 27 Feb 2014 19:49:09 GMT

This comment gave me a light, the problem was in the SQL statement, on the conversion from datetime to date. Thank you all!

Re: linking dates problem

Thu, 27 Feb 2014 19:49:44 GMT

the subroutine is ok! thanks!

Re: linking dates problem

Anonymous — Thu, 27 Feb 2014 19:55:46 GMT

You have a problem with Date in the DateLink table - it is timestamp

Use
floor(CREATE) as Date

floor(COMPLETED) as Date

There is something else besides this...

Re: linking dates problem

Anonymous — Thu, 27 Feb 2014 19:56:51 GMT

Edit - no, that's it I guess

Re: Re: linking dates problem

Anonymous — Thu, 27 Feb 2014 20:01:01 GMT

In fact my first comment wasn't important - but the one about the floor() was. Dates were not linked because they had different values in two tables - integer in calendar but timestamps in Link.

See attached.