topic Re: Combing 2 fields data into one in QlikView

Combing 2 fields data into one

Tue, 19 Mar 2013 04:38:45 GMT

Hi All,

I have the following table:

StudentId,MemberId

1,2

2,3

3,4

After loading it into the Memory, is it possible to let them into one field with expression not during the loading time period?

Thanks.

Re: Combing 2 fields data into one

Anonymous — Tue, 19 Mar 2013 04:49:43 GMT

As shown in the screenshot.

Is this what you are trying to accomplish?

Re: Combing 2 fields data into one

Tue, 19 Mar 2013 04:52:53 GMT

Hi,

In the expression of your list box or straight table or wherever you are planning to display it, you can use the following expression:

=StudentID & ' ' & MemberID

Re: Combing 2 fields data into one

sivarajs — Tue, 19 Mar 2013 06:35:49 GMT

SubField(StudentId&','&MemberId,',')

Re: Combing 2 fields data into one

Tue, 19 Mar 2013 07:08:37 GMT

What I want is use one field to show like:

The result is

instead of use comma to show them together.

Re: Combing 2 fields data into one

er_mohit — Tue, 19 Mar 2013 07:20:25 GMT

TRY THIS

=concat( StudentId ,',')& ',' &Concat(MemberId,',')

Re: Combing 2 fields data into one

Anonymous — Wed, 20 Mar 2013 23:32:29 GMT

I don't think you can do that on expression level.

By the nature of QlikView, when you select a value, you select a value in a field. Merging two fields of data into one listbox just doesn't make sense -- when you select a value, which field is selected?

Doing this on load script level makes sense because you are basically creating a new field that contains all the data from both.

Re: Combing 2 fields data into one

Thu, 21 Mar 2013 09:36:59 GMT

try this

SubField(StudentId &',' & MemberId ,',' )

************************************************************

LOAD * INLINE [

StudentId, MemberId

1, 2

2, 3

3, 4

];

LOAD StudentId as combined

Resident a;

LOAD MemberId as combined

Resident a;

DROP Table a;