topic Data Model issue in QlikView

Data Model issue

Anonymous — Fri, 19 Nov 2010 14:22:09 GMT

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

Data Model issue

Fri, 19 Nov 2010 14:31:26 GMT

Hi,

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.

Regards, Roland

Data Model issue

flavio_fazzano — Fri, 19 Nov 2010 14:39:56 GMT

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

Data Model issue

Anonymous — Sat, 20 Nov 2010 05:12:31 GMT

Hi Roland,

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.

Data Model issue

Sat, 20 Nov 2010 22:37:06 GMT

Hi,

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).

I think this points into right direction,

Roland

Data Model issue

Sun, 21 Nov 2010 11:52:46 GMT

Hi,

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.