Qlik Community

New to Qlik Sense

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anagharao
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
MohasinKhan
Contributor III
Contributor III

Hi,

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.

Almen
Creator
Creator

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