2 Replies Latest reply: Feb 8, 2017 6:35 PM by Rob Wunderlich RSS

    How to make multiple rows into one row in multiple columns

    Susan Liu

      I am new in Qlik Sense. I am learning how to make multiple rows into one row in multiple columns for a report. For example,

       

      ID     Sale Date       Product         Price

      A      01-02-2017     book              50

      A      01-02-2017     computer        500

      B      02-01-2017     Phone            60

      B      02-01-2017     cup                10

       

       

      I want to merge the rows like this.

       

      ID     Sale Date       Product1        Price1     Product2     Price2

      A      01-02-2017     book              50           Computer    500

      B      02-01-2017     Phone            60           cup             10

       

      Any help always appreciate. Thanks in advance!