Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

 

 

 

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

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

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

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

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

Highlighted

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

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

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)
Highlighted
Contributor II
Contributor II

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

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.

 

 

 

 

 

Highlighted
Creator II
Creator II

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

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