topic Date Problem. in QlikView

Date Problem.

Wed, 15 Dec 2010 11:49:43 GMT

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?

Date Problem.

SunilChauhan — Wed, 15 Dec 2010 11:56:50 GMT

try to Rename one field

Date Problem.

Wed, 15 Dec 2010 11:59:40 GMT

Thanks for your quick reply

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

Date Problem.

deepakk — Wed, 15 Dec 2010 12:03:35 GMT

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.

Date Problem.

Wed, 15 Dec 2010 13:20:39 GMT

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

Thank you for your help!

Date Problem.

Anonymous — Wed, 15 Dec 2010 16:23:05 GMT

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

Date Problem.

Wed, 15 Dec 2010 16:35:35 GMT

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

Date Problem.

Wed, 15 Dec 2010 16:39:48 GMT

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

Date Problem.

Thu, 16 Dec 2010 08:13:24 GMT

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

Regards Luuk

Date Problem.

deepakk — Thu, 16 Dec 2010 08:28:52 GMT

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.