hi, i have problem in developing a data model in qlikview. I have one calander qvd file in that i have date from 01.01.1995 to 31.12.2010 and another data with excel having transcation data in that one date column is there. when i used to link the date column from QVD and date column from excel the link is not proper. guide me is there anything i need to check while dev data model with date function
date formats are often different and allmost timeconsuming. To see whats your problem it would be easier for all if you post an example app. Just a few rows from your excel and qvd in a qvw to see what happens.
It is true that Roland said. You could put on screen a list box for Date_Field and you'll see distinct date formats, if some data are uploaded as text you´ll see on left
I have checked the data but still it is not showing proper link with the excel Date. I have uploaded my app with limted data could u please and check n tell me what is the issue.
it is as I assumed it. Your date-fields do not fit together. You can check it i.e with a table box. There you can see two rows with the similar looking date-format, but in fact these are two different rows because the date-formats do not fit together. Check my attachement.
Now there is more then one possibility. My favorite is using a number as key to link the tables together. You can use the num() - function to convert both fields (DateLink) to number. Second posibility is to use a DateLink like this: Num(Year & Month & Day) As DateLink or better you name it as $Date_ID. (doing with both fields).
in addition to my post above you should format the column DateLink of the table box as a timestamp. You will see two "date" fields being in reality timestamps (and with two different values !). To be more precise as in my post above: they seem to be equal as dateformatted but they have two different time values. Thats the main reason why I am not using dates or similar as key fields to link tables.
