topic concat in QlikView

concat

Thu, 29 Mar 2012 03:47:03 GMT

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

Re: concat

Thu, 29 Mar 2012 03:53:28 GMT

hi,

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

Example: field1 & field2

here is the attached example:

concat

Thu, 29 Mar 2012 04:14:08 GMT

the first concat field is a1 but i want output as

row 1: a

row 2 : 1

not a1 then what to do?

Re: concat

Thu, 29 Mar 2012 04:16:32 GMT

Use:

row1 & ':' & row2

Regards

Arun Goel

Re: concat

Thu, 29 Mar 2012 04:20:14 GMT

I dont understand what you try to do...

Would you please explain more?

concat

Thu, 29 Mar 2012 04:24:09 GMT

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????

Re: concat

Thu, 29 Mar 2012 04:25:13 GMT

Found the attached file:

See the calculated dimension and expression of table

concat

Thu, 29 Mar 2012 11:18:59 GMT

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.

concat

Thu, 29 Mar 2012 11:26:43 GMT

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

concat

SunilChauhan — Thu, 29 Mar 2012 11:34:52 GMT

use below code

'Row1:'&field1&'

'&'Row2:'&field2

hope this helps