topic Join two tables in QlikView

Join two tables

youss123 — Mon, 17 Jan 2022 15:19:38 GMT

Hi all,

I have a calculated expression which concatenates 5 values from a column and make them as a single number.

I have a tabt that I pulled from excel which, for each combination of 5 numbers gives a value between 0 and 1.

can I join the two tables in such a way that I have the correct value between 0 and 1 of each 5 number combination of my calculated expression?

Calculated Expression:

Concat({ <[filter1] ={'v1'},[filter2]={'v2'},[KEY]={'v_1','v_2','v_3','v_4','v_5'} >}[resp_value] , '')

Any help will be appreciated

best regards

rwunderlich — Mon, 17 Jan 2022 15:51:11 GMT

The best approach is to create the calculated field in the script and name it the same as "Col1".

-Rob

danialclose — Fri, 04 Feb 2022 07:14:56 GMT

@rwunderlich wrote:

The best approach is to create the calculated field in the script and name it the same as "Col1".

-Rob friday night funkin

Will do. Thank you!!