Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Concatenation vs link tables

Hi Everyone

I would like to know which one of the below leads to better utilization of RAM and how each affects the performance of the dashboard.

Option 1: Concatenation

SUM({<Scenario={'Actual'}>} Amount)  + SUM({<Scenario={'Budget'}>} Amount)

Option 2:  Link table

SUM(Actual) + Sum(Budget)

2 Replies
Contributor III
Contributor III


In my experience, either of those do not make much of a difference, it is best to use what you are comfortable with (the simpler the better)

The type of charts you use, cause lagging and delays on the dashboard page.

If you use any of the default charts, you should be ok. Try and avoid using custom objects.

Hope this helps.


What about SUM({<Scenario={'Actual', 'Budget'}>} Amount)? Plain SUM is generally not problematic in terms of loadspeed.