Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Tags (1)
1 Solution

Accepted Solutions
aarkay29
Valued Contributor

Re: How to combine multiple columns?

Just try

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

2 Replies
aarkay29
Valued Contributor

Re: How to combine multiple columns?

Just try

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

Not applicable

Re: How to combine multiple columns?

Thanks Aar Kay! It worked.

Community Browser