topic problem with linking dates in QlikView

problem with linking dates

Tue, 14 Sep 2010 15:33:58 GMT

Hello,

I have two data sets that I want to connect with a common 'date' field. One data set has sales numbers and the other has weather information. Basically what I'm trying to achieve is to create a date field that when selected will show me sales and weather for that selected date. I'm not sure why it isn't working for me, maybe because of date format? I attached my qvw file

Thanks

problem with linking dates

Tue, 14 Sep 2010 15:50:43 GMT

Hi,

you can make acommon date format like ........

date(salesdate,'dd/mm/yyyyy') as date

and

date(weatherdate,'dd/mm/yyyyy') as date

similiarly u can extract month and year from these date fields

hopw that will work .....

Regards,

Dushyant

problem with linking dates

disqr_rm — Tue, 14 Sep 2010 15:51:21 GMT

You may use DayStart() function to fix this problem. The reason is that your date field also has time associated within. Something like this should work:

date(daystart(weather.date)) as Date
date(daystart(Date1)) as Date

Hope this helps.

problem with linking dates

Tue, 14 Sep 2010 15:59:05 GMT

Thanks for very prompt responses.

Dushyant I tried changing date format but it doesnt work me.

Rakesh's solution works for me. It seems like time was the issue.

Thanks