2 Replies Latest reply: Sep 18, 2017 1:26 PM by Sathwik Vangari RSS

    How to combine multiple columns?

    Sathwik Vangari

      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.