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: 
Not applicable

concat

Is it possible to concat two fields in the same table n how?

9 Replies
Not applicable
Author

hi,

yes you can concat two field in dimension or expression using & operator

Example:   field1 & field2

here is the attached example:

Not applicable
Author

the first concat field is a1 but i want output as

row 1:  a

row 2 : 1

not a1 then what to do?

Not applicable
Author

Use:

row1 & ':' & row2

Regards

Arun Goel

Not applicable
Author

I dont understand  what you try to do...

Would you please explain more?

Not applicable
Author

m nt able to tel u what i want xactly....

i have 2 different date fields n i want to join master calenders date field to both but i can join it to any 1 field at a time for tat reason i want to join these two date fields and make it as a single field so that i can join it to my master calender date field...... is there ny other way to solve such problem????

Not applicable
Author

Found the attached file:

See the calculated dimension and expression of table

Not applicable
Author

Hi,

Just concatenate both the Tables

EG:

Table1:

ID   Date             Date1

1    11/12/2011    13/12/2011

2    12/12/2011     14/12/2011

so,

in qlikview,

Table1:

Load ID,Date from Table1.xls;

concatenate(Table2)

Load ID,Date1 as Date from Table2.xls;

final output:

ID Date

1   11/12/2011

2    12/12/2011

1    13/12/2011

2    14/12/2011

Then join this with master calendar Date field.

Not applicable
Author

Hi ,

what you want to say is concatenating fields means creating a composite

key then waht arun Goel is saying is correct.

Warm Regards

Anant Dubey

SunilChauhan
Champion
Champion

use below code

'Row1:'&field1&'

'&'Row2:'&field2

hope this helps

Sunil Chauhan