Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linktable/Concatenation which is better?

Dear All,

Linktable or Concatenation which is better

3 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi Shweta,

If no. of records are very large, go for concatenation.

For expressions to work across tables via link will be performance intensive.

However if its a small dashboard, both are valid ways and it will not make a difference.

You can use what your design permits.

thanks,

Rajesh Vaswani

its_anandrjs

Hi,

Concatenation is better option rather than linktables and if you have single or two three fields are common then create the link tables for the tables.

While creating the concatenation of the tables us Table flag

load *,'Tab1' as TableFlag From Source1;

Concatenate

load *,'Tab2' as TableFlag From Source1;

Regards,

Anand

Yousef_Amarneh
Partner
Partner

If the data volume is not very huge then use linktable since the data model will be more clear in the front-end.

Yousef Amarneh