4 Replies Latest reply: Aug 26, 2016 7:07 AM by Ravi Krishna Reddy Chinta RSS

    How to manually group columns in Qlik Sense pivot table

    Ravi Krishna Reddy Chinta

      Hi,

       

      Is there any way to group two columns into a one group and another two columns into another group in Qlik Sense Pivot table?

       

      For better understanding of my requirement, please read below description:


      1) I am creating a Pivot table that has [Regions] dimension in Rows and four measures namely sum[Sales], sum([Sales Quantity]), sum([Buy Price]), sum([Buy Quantiity]) in Columns. Now the default output that I am getting is as shown in the below image.

      Actual Output.JPG

       

      2) Now, my requirement is to display sum([Sales]), sum([Sales Quantity]) as "Sales Group" and sum([Buy Price]), sum([Buy Quantity]) as "Buy Group" as shown in the below image.

      Expected Output.PNG

       

      Could someone please help me how to achieve this? I have also attached a sample database file for your convenience.

       

      Thanks in advance,

      Ravi