Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just try
Firstname &' '& middle name & ' ' & Last Name
Thanks Aar Kay! It worked.