Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Key Column in Link Table

Hello,

What is the purpose behind concatenating all dimensions to form Key column in Link Table?

1 Reply
Highlighted

Key field will generate one club values based on delimiter to produce the Autonumber. For Ex:

Load * Inline [

Name, Company, Sales

A, A1,

B, B1

];

And condition as follows to generate key

Name & '|' & Company as Key

Output: A|A1 and B|B1

Where as Below condition will produce

AutoNumber(Name & '|' & Company) as Key

Output: 1 and 2

You can use Key as filter for selection from entire model.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)