Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Key Column in Link Table


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

1 Reply

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)