topic Re: Merging data from two tables and present in a single straight table chart in QlikView

Merging data from two tables and present in a single straight table chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Example -

Table 1:

Col1,

Col2,

Col3

Table 2:

Col4,

Col5,

Col6

both tables are not related but column significance is same. In straight table chart how to merge both tables data and show.

am looking for a output like below

col1/col4(col1 & col4 values to be merged and shown in single column) col2/col5 col3/col6

My requirement does not allow me to do this at the script level and has to be on the presentation layer.

Can anyone help??

olivierrobin — Fri, 23 Mar 2018 16:39:44 GMT

hello

what do you want ?

one total line with sum of each column pair

one row per row on input table ? in this case, is there a way to match lines together ?

shiveshsingh — Fri, 23 Mar 2018 16:41:53 GMT

Merging means? concatenating the columns in chart?

cazztfplease — Fri, 23 Mar 2018 18:18:10 GMT

You could do something like this?

LinkedColumn:

Load Col1 & '/' & Col4 as Col1_Col4,

Col2 & '/' & Col5 as Col2_Col5,

Col3 & '/' & Col6 as Col3_Col6

cazztfplease — Fri, 23 Mar 2018 18:20:35 GMT

Apologies. Just saw that you could not do it in script.

cazztfplease — Fri, 23 Mar 2018 18:26:49 GMT

You can however use similar logic in the UI.

You can add a calculated dimension and use the script from above. For example:

= Col1 & '/' Col4

You can then label it as Col1/Col4 or whatever you like in the label prompt box.