topic Pivot table and Grand Total issues!!! in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325015#M119725 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%;">Hello Everybody,</SPAN></DIV><DIV> </DIV></SPAN></DIV><DIV><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">I used Pivot table to summary information with 2 separated tables.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">The problem is I want to use another table to display a grand total value of 2 tables above.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Please advise me the best way to implement it.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Please take a look on attached picture to get more detail.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Thanks,</SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Tai.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV></BODY></HTML> Tue, 28 Jun 2011 04:57:41 GMT 2011-06-28T04:57:41Z Pivot table and Grand Total issues!!! https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325015#M119725 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%;">Hello Everybody,</SPAN></DIV><DIV> </DIV></SPAN></DIV><DIV><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">I used Pivot table to summary information with 2 separated tables.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">The problem is I want to use another table to display a grand total value of 2 tables above.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Please advise me the best way to implement it.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Please take a look on attached picture to get more detail.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Thanks,</SPAN></DIV><DIV class="MsoNormal" style="margin: 0in 0in 10pt;"><SPAN style="color: #333333; line-height: 115%; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Tai.</SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></DIV></BODY></HTML> Tue, 28 Jun 2011 04:57:41 GMT https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325015#M119725 2011-06-28T04:57:41Z Pivot table and Grand Total issues!!! https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325016#M119726 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you share sample data or Qlikview file?</P><P>It will help us understand what expressions you used and how it can be summarized.</P></BODY></HTML> Tue, 28 Jun 2011 05:15:17 GMT https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325016#M119726 2011-06-28T05:15:17Z Pivot table and Grand Total issues!!! https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325017#M119727 <HTML><HEAD></HEAD><BODY><P>The formula you want depends on the data structure and the forumlas in the existing charts. If you attach your .qvw file it will be easier to help you out</P></BODY></HTML> Tue, 28 Jun 2011 05:25:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-and-Grand-Total-issues/m-p/325017#M119727 Anonymous 2011-06-28T05:25:07Z