Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Simple link between two tables

Hello community,

I had to link two tables in the script but i didn't know how to do in a right way.

Frist table:

Weeknumber, Operation, Sort, Number

Second table:

Weeknumber, ......

How can i link the two Weeknumbers correctly in the script?

Thanks for help!

1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: Simple link between two tables

Just make sure the field "Weeknumber" is spelled exactly the same in both tables. That should do it.

Keep in mind that Qlik is Case Sensitive!

The one and only way to connect tables is by naming the fields correctly. Qlik has the opinion that if something is the same thing, you should give it the same name. If something is not the same thing, it should not have the same name.

I know, sounds pretty logical, but apparently not every software company thought of it that way the last 50 years .

May you live in interesting times!
1 Reply
oknotsen
Honored Contributor III

Re: Simple link between two tables

Just make sure the field "Weeknumber" is spelled exactly the same in both tables. That should do it.

Keep in mind that Qlik is Case Sensitive!

The one and only way to connect tables is by naming the fields correctly. Qlik has the opinion that if something is the same thing, you should give it the same name. If something is not the same thing, it should not have the same name.

I know, sounds pretty logical, but apparently not every software company thought of it that way the last 50 years .

May you live in interesting times!
Community Browser