Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
TomHolland
Contributor II
Contributor II

Merging/joining Data from different fields into 1 field

From Excell I load into Qlikview the following Table:
 
67017
127540
610043
 
In Qlikview I made a Table Object that shows above date in the same way:
 
67017
127540
610043
 
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

 

 

 

Labels (1)
1 Solution

Accepted Solutions
zzyjordan
Creator II
Creator II

Hi, Tom

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

Untitled.jpgHope this helps

ZZ

View solution in original post

4 Replies
zzyjordan
Creator II
Creator II

Hi, Tom

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

Untitled.jpgHope this helps

ZZ

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
TomHolland
Contributor II
Contributor II
Author

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
Creator II
Creator II

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

Untitled.jpg

Hope  this helps

ZZ