Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

Raji, 

result is appearing as 0,0

here is my experssion:

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

 

Highlighted
Creator
Creator

Raji, 

It did work! 

thanks a million

Regards

Jose