Merging/joining Data from different fields into 1 field

[TomHolland]

From Excell I load into Qlikview the following Table:

6	70	17
12	75	40
6	100	43

In Qlikview I made a Table Object that shows above date in the same way:

6	70	17
12	75	40
6	100	43

However I would like Qlikview to display the data in the Tableobject as follows:

6/70/17

12/75/40

6/100/43

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

[TomHolland]

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 · Accepted solution]

Hi, Tom

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

Hope this helps

ZZ

[Anil_Babu_Samineni]

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

[TomHolland]

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?

T.

[zzyjordan]

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

ZZ