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.
