topic Combine two fields into one single dimension Qliksense in App Development

Combine two fields into one single dimension Qliksense

Aspiring_Developer — Thu, 04 Aug 2022 08:05:08 GMT

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

Re: Combine two fields into one single dimension Qliksense

vidyutverma — Thu, 04 Aug 2022 10:08:31 GMT

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

Re: Combine two fields into one single dimension Qliksense

Aspiring_Developer — Thu, 04 Aug 2022 10:59:01 GMT

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

Re: Combine two fields into one single dimension Qliksense

Mark_Little — Thu, 04 Aug 2022 11:10:42 GMT

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?

Re: Combine two fields into one single dimension Qliksense

Lakshminarayanan_J — Thu, 04 Aug 2022 11:39:59 GMT

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.