5 Replies Latest reply: Jun 13, 2018 1:00 AM by Marcus Sommer RSS

    Converting/Transforming rows data into columns

    Amita Khera

      I am working on a problem in Qliksense and would highly appreciate your help. I have a table with client survey data with multiple rows of data by stage that I need to combine into columns such that each stage becomes a column. And then I want to calculate the difference between Min(Stage Number) and Max(Stage Number) value

      base file.jpg

       

      This needs to be converted into :

      Transformed file.jpg

      The file expected output is a file that has the starting score and the latest score ( irrespective of stage)

      Output file.jpg

      Any help/leads on this would be highly appreciated