Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
TomHolland
New 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
zzyjordan
Contributor 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

4 Replies
zzyjordan
Contributor 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

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)
TomHolland
New 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.

 

 

 

 

 

zzyjordan
Contributor 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