topic Re: Unable to Map Master calendar with Date field in QlikView

Unable to Map Master calendar with Date field

fashid — Tue, 26 Apr 2016 05:19:21 GMT

Hi,

I am having a strange issue in mapping my calendar with QUOTE_APPROVED_DT.

I have created a master calendar to map to the QUOTE_APPROVED_DT but the calendar is not mapping correctly.

The CalendarDate is having blank values in certain rows.

I am attaching the sample app and qvd .

I would be if anybody could look into it

Regards,

Nadeem

Re: Unable to Map Master calendar with Date field

robert_mika — Tue, 26 Apr 2016 05:42:32 GMT

Do you have any jobs for those missing days?

Re: Unable to Map Master calendar with Date field

fashid — Tue, 26 Apr 2016 05:48:51 GMT

Hi ,

Thanks for the reply

Yes there are jobs

Re: Unable to Map Master calendar with Date field

mightyqlikers — Tue, 26 Apr 2016 05:51:08 GMT

Dear Nadeem,

PFA,

$@M.

Re: Unable to Map Master calendar with Date field

fashid — Tue, 26 Apr 2016 05:57:27 GMT

WHOOOAAAAA .....

That does it

Could you please explain what the issue was . It would be of great help

I do see you have used the date functions seems some problem with the date but i do not understand what was the actual issue .

Regards,

Nadeem

Re: Unable to Map Master calendar with Date field

mightyqlikers — Tue, 26 Apr 2016 06:01:15 GMT

date field consists of timestamp also cause of that it is making problem with master calendar.

Hope the post was correct.

$@M

Re: Unable to Map Master calendar with Date field

fashid — Tue, 26 Apr 2016 06:04:54 GMT

Yes Sir Thanks a lot . I just could not understand what the issue was and was struggling with this because i had to implement a canonical date concept .

I have also posted the same in the community .

Regards,

Nadeem Shaikh