Problem to link dates

chematos — Wed, 22 Feb 2012 20:01:36 GMT

Hi,

Something unusual is happening to me. I always link in the same way the dates of any table with my Calendar and I have any problem, until now.

I use the Date() function and the dates are like this: 'DD-MM-YYYY'

DATE(Info_TimeStamp) as %Date

I have a table Calendar and my %Date field has the same format than the other %Date of my fact table and the link appears on the diagram.

Is like there were two different fileds %Date, one with only one date by day and other with repeated dates by day because in one day there are a few operations but in other qvw always appears one date by day.

Now, if I select a month, the field %Date looks fine but if I select a %Date of one table, there is no selection in my calendar fileds, no month, no year, no day... and if I do any selection and I review my field %Date, there are repetead dates.

I have no idea what is happening, in other qvw this is working perfectly so if anyone has any idea I will thank you.

Regards,

José

Problem to link dates

Wed, 22 Feb 2012 21:22:31 GMT

Can you upload your qvw?

Problem to link dates

rwunderlich — Wed, 22 Feb 2012 21:59:40 GMT

Date() is a formatting function that only controls the display value of the field. So your %Date field is still a timestamp. Try

DATE(floor(Info_TimeStamp)) as %Date

-Rob

http://robwunderlich.com

Problem to link dates

chematos — Thu, 23 Feb 2012 11:17:09 GMT

Thank you Rob,

I´m glad to know what is the origin of the problem.

Regards

-José

topic Problem to link dates in QlikView

Problem to link dates

Problem to link dates

Problem to link dates

Problem to link dates