Date Problem.

[#1]

Hey i am once more trying some things in qlikview.

Im trying to combine 2 creation dates into 1 master calender. ( well only the weeknumbers)

The only problem im having is that im getting a syn tabel. This syn table is caused by a other field. when i remove the mastercalnder table

i don't have any syn tables. Or when i rename 1 of the PK_R_employee but i of course need them both.

Any Ideas on how to remove this syntable?

[SunilChauhan]

try to Rename one field

[#3]

Thanks for your quick reply

I did it does remove the syntable but then i lose my connections.

[deepakk]

Hi,

Create a composite key in both thee tables and link using the key.

eg:

(Field1 & '-' & Filed2) as Key

you can also use the autonumber function to create the composite key.

[#5]

Any chanse you could show a sample example of what you mean?

Thank you for your help!

[Anonymous]

If you send me (or upload) your script I will gladly edit it for you the way Deepak suggests.

[#7]

I added the file @ my profile cause it doenst seem to work at the forums anymore.

This would be a great help to me.

Alvast bedankt Luuk

[#8]

Hi

what he does mean is

Projecttime:
PK_R_EMPLOYEE & '_' & WEEK as Key,
// PK_R_EMPLOYEE,
// WEEK
.......
..........
;
Facturen:
PK_R_EMPLOYEE & '_' & WEEK as Key,
// PK_R_EMPLOYEE,
// WEEK
.......
..........
;

// comment the individual Fields as above

Do the same for Facturen Table and build the same key as above in PROJECTTIME Table

Now the two tables PROJECTTIME and FACTUREN are linked by a common KEY "key" and the Synthetic key will be vanished

Hope that helps

[#9]

But now they are no longer linked with the Employee Table.

Regards Luuk

[deepakk]

hi,

Since you have commented the filed from both the tables, you are not able to see the original two fields.

DOnt comment the two fields from both the table.

Comment only from one of the table.

In this case you will have the composite key as well as the two fields.