Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to combine multiple columns?

Hello! I am pretty new to Qliksense. I am working on a dataset which has three columns (first name, middle name, last name) for names of sales persons and sales acheived as a measure. I want to combine the three columns to use full name (concat of first name, middle name and last name) as a dimension in plotting sales acheived. I tried using concat() function, but it doesn't work in the data load as it concatenates tables and only takes two arguments. I tried concat() function to create an expression in 'add dimension' feature on the sheet, but once I use concat(), the chart says invalid dimension.

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

Just try

Firstname &' '& middle name & ' ' &  Last Name

View solution in original post

2 Replies
aarkay29
Specialist
Specialist

Just try

Firstname &' '& middle name & ' ' &  Last Name

Not applicable
Author

Thanks Aar Kay! It worked.