Combine two fields into one single dimension Qliksense

[Aspiring_Developer]

Hello All,

I have below fields in my data model and I have used them as filter like below :-

I wish to combine them into one single dimension named as 'Speed' covering the values in both the fields.

I tried using concat but it is giving me the values of only first dimension and not for the second one.

Can anyone please anyone ?

Thanks in advance

[vidyutverma]

Could you share your script? Concate should have worked, if you are renaming both fields to Speed.

[Aspiring_Developer]

Hi @vidyutverma 

Thanks for your response.

Both the fields are coming from different tables and I tried to concatenate in front end. Here is my script:-

Thanks

[Mark_Little]

Hi

Would need the Two dimension on a single table then you can something like you did in with brand and date to get key_SpeedB.

Where you create your link table, can you not join the values in? create you combined dimension and maybe drop the fields again?

[Lakshminarayanan_J]

Hi @vidyutverma ,

1. Kindly try to concate the script .  Speed and Speed_Bracket . And rename the field " Speed Bracket " as Speed  and load the data( It will concate Automatically)

2. Rename the Speed Bracket Field as Speed and join the table.