Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Merging fields

Hi All,

I have one table, which contains fields A, B, C, D, E.

My requirement is i want to merge 3 fields as one field

like A,B, C as A1,

B,C,D as B1

And for these A1, B1 Again i have to create one field as follows

A1
A
B
C

B1
B
C
D

TOTAL
A1
B1

is there any possibility in Qlikview?

Please help me on this

Thanks,

Vamsi.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Re: Merging fields

May be like attached sample

View solution in original post

7 Replies
Highlighted
MVP
MVP

Re: Merging fields

Though not very clear, you can try:

Load

          A1,

          B,

          A1&B1 as TOTAL

;

Load

          A&B&C as A1

          B&C&D as B1

From <>;

note: '&' is string concatenation operator, if you want to add the numeric values you can similarly use '+' like:

Load A+B+C as A1 ....

Highlighted
Not applicable

Re: Merging fields

hi

can you give data sample

Highlighted
Master III
Master III

Re: Merging fields

Reddy ,

It is confusing little bit.

Highlighted
Not applicable

Re: Merging fields

I have one table which contains fields COMPANY, COMPANY_2,STATE .  Requirement is I want to show COMPANY, COMPANY_2,STATE as Address filed in list box as follows

SS1.PNG.png

Please can anyone help on this.

Thanks,

Chiru

Highlighted
Not applicable

Re: Merging fields

Hi

use like this ,

Address:

load * inline [

city,state,country,hno

chennai,tamilnadu,india,14

hyd,AP,india,23

];

LOAD city &'    '& state &'    ' & country&'    ' & hno as addres Resident Address;

Highlighted
MVP
MVP

Re: Re: Merging fields

May be like attached sample

View solution in original post

Highlighted
Not applicable

Re: Merging fields

HI tresesco,

This is exactly what i'm expecting is

Thanks for your support on this.

Thanks,

Vamsi