topic Re: Merging/joining Data from different fields into 1 field in QlikView

Merging/joining Data from different fields into 1 field

TomHolland — Sat, 16 Nov 2024 21:42:30 GMT

Joining the data from the 3 fields seperating them bij a / and showing them in 1 field.

Is this possible, and if so how?

Tom

zzyjordan — Thu, 20 Dec 2018 00:47:29 GMT

Hi, Tom

Have you tried to concatenate your 3 columns in the script loading as shown below?

Hope this helps

Anil_Babu_Samineni — Thu, 20 Dec 2018 03:55:19 GMT

Are you going to use in front end which is expected field? If so, What purpose you used?

TomHolland — Fri, 21 Dec 2018 15:56:16 GMT

Hi ZZ,

Your suggestion worked.

But now I have another problem.

I would like for Qlikview to display only the "newfield".

However I use the fileds a b c to sort the data.

If I do not include fields a b c in the table object Qlikview displays "newfield" in the wrong order.

Is there a solution for this?

zzyjordan — Sun, 23 Dec 2018 23:56:49 GMT

Hi, Tom

Probably you can try sort the new field by using the rank expression as below

rank(a)*100+rank(b)*10+rank(c)

and the result should be something similar as below

Hope this helps