Combining Measures into One table

[dr323]

I am very new to Qlik and I am trying to create a single data table. I have created several very simple bivariate correlation measures with each producing a single value. What I am looking to do is combine these measures into a single Data Table. I have attached a very simple example of where I am stuck. I am able to create the bar chart by dropping each correl in separately, but I would like to have them all added to a single data table to then add to different charts. There may be a simpler way to approach the issue of trying to display correlations between a single outcome and several other variables. 

[Elias_w]

Use link tables, concatenation, compound keys, or joins to combine measures.

[Bhushan_Mahajan]

@dr323 Use concatenation and flag each cor to identify the individual cor.

[diegozecchini]

Hi!
To combine your bivariate correlation measures into a single data table in Qlik Sense, you can concatenate your measures into a single table and add a flag or identifier for each correlation measure. This allows you to differentiate between the measures while keeping everything in one data structure.

Here’s an example script:

// Load each measure into separate tables
CorMeasure1:
LOAD
'Measure1' AS MeasureName,
CorrelationValue AS Correlation
FROM [YourDataSource1];

CorMeasure2:
LOAD
'Measure2' AS MeasureName,
CorrelationValue AS Correlation
FROM [YourDataSource2];

// Concatenate all measures into one table
ConcatenatedTable:
LOAD * RESIDENT CorMeasure1;
CONCATENATE (ConcatenatedTable)
LOAD * RESIDENT CorMeasure2;

// Drop intermediate tables
DROP TABLE CorMeasure1;
DROP TABLE CorMeasure2;
This script creates a single table, ConcatenatedTable

You can repeat the process for all your measures.