Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chematos
Specialist II
Specialist II

Problem to link dates

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é

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
Not applicable

Can you upload your qvw?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

chematos
Specialist II
Specialist II
Author

Thank you Rob,

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

Regards

-José