Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

concatenate two dimensions on a table

Hi there, 

 

could anyone assist with  the following:

I would like to concatenate tow dimensions on a single table row.

See table example: 

From: 

dimension 1dimension 2
data 1data 2

 

To:

dimension 1, dimension 2
data 1, data 2

 

Could anyone assist with the syntax?

Thanks a million.

Jose

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

hi ,

here is the solution.

use the below expression:

dimension 1 & ',' & dimension 2

 
 

cheers,

Raji

 

View solution in original post

3 Replies
Highlighted
Creator II
Creator II

hi ,

here is the solution.

use the below expression:

dimension 1 & ',' & dimension 2

 
 

cheers,

Raji

 

View solution in original post

Highlighted
Contributor III
Contributor III

Raji, 

result is appearing as 0,0

here is my experssion:

=[Close Calls Detail 1] & ','& [Close Calls Detail 1A]

 

Highlighted
Contributor III
Contributor III

Raji, 

It did work! 

thanks a million

Regards

Jose