topic How to display data like this in Straight table or in Pivot Table? in QlikView https://community.qlik.com/t5/QlikView/How-to-display-data-like-this-in-Straight-table-or-in-Pivot/m-p/120171#M509608 <HTML><HEAD></HEAD><BODY><P>I want to display data in <STRONG>Group wise</STRONG> total in either Pivot Table or in Straight Table.</P><P>Can you please suggest me to how to implement to display output on this below screenshot.</P><P><IMG alt="Ca.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214699_Ca.PNG" style="width: 620px; height: 122px;" /></P></BODY></HTML> Fri, 28 Sep 2018 12:11:22 GMT whitestonek 2018-09-28T12:11:22Z How to display data like this in Straight table or in Pivot Table? https://community.qlik.com/t5/QlikView/How-to-display-data-like-this-in-Straight-table-or-in-Pivot/m-p/120171#M509608 <HTML><HEAD></HEAD><BODY><P>I want to display data in <STRONG>Group wise</STRONG> total in either Pivot Table or in Straight Table.</P><P>Can you please suggest me to how to implement to display output on this below screenshot.</P><P><IMG alt="Ca.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214699_Ca.PNG" style="width: 620px; height: 122px;" /></P></BODY></HTML> Fri, 28 Sep 2018 12:11:22 GMT https://community.qlik.com/t5/QlikView/How-to-display-data-like-this-in-Straight-table-or-in-Pivot/m-p/120171#M509608 whitestonek 2018-09-28T12:11:22Z Re: How to display data like this in Straight table or in Pivot Table? https://community.qlik.com/t5/QlikView/How-to-display-data-like-this-in-Straight-table-or-in-Pivot/m-p/120172#M509609 <HTML><HEAD></HEAD><BODY><P>Hi Satish</P><P></P><P>Best to use a Pivot Table to achieve this result:</P><P><IMG alt="PivotTotal.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214704_PivotTotal.PNG" style="height: 164px; width: 620px;" /></P><P>Total is on the dimension [Vehicle Number].</P><P>Mind, this is made in Qlik Sense, but the same should be possible for QlikView.</P></BODY></HTML> Fri, 28 Sep 2018 12:36:45 GMT https://community.qlik.com/t5/QlikView/How-to-display-data-like-this-in-Straight-table-or-in-Pivot/m-p/120172#M509609 timpoismans 2018-09-28T12:36:45Z