Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.