topic Re: Merge Pivot tables together in QlikView https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620665#M1112441 <HTML><HEAD></HEAD><BODY><P>If you could upload your sample file, will definitely try to help you.</P></BODY></HTML> Sun, 23 Feb 2014 19:38:04 GMT MK_QSL 2014-02-23T19:38:04Z Merge Pivot tables together https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620664#M1112440 <HTML><HEAD></HEAD><BODY><P>I attached the tables i have:</P><P></P><P>-First how can i get the Percentage in table 3 as 647/ (647+589) and so on.</P><P></P><P>-Second i need to merge the tables together in order&nbsp; TABLE 1 - TABLE 2 - TABLE 3 so i get the table as follow</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="680"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P><STRONG style="color: black;">Waiting Time</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P><STRONG style="color: black;">Visit Type</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><OL style="list-style-type: upper-alpha;"><LI><STRONG style="color: black;">Freq.</STRONG></LI></OL></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="87"><P><STRONG style="color: black;">Percentage%</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><OL style="list-style-type: upper-alpha;"><LI><STRONG style="color: black;">Freq.</STRONG></LI></OL></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="87"><P><STRONG style="color: black;">Percentage%</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P><STRONG style="color: black;">Visit Type</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><OL style="list-style-type: upper-alpha;"><LI><STRONG style="color: black;">Freq.</STRONG></LI></OL></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P><STRONG style="color: black;">Percentage%</STRONG></P></TD></TR><TR><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid black 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="92"><P><STRONG style="color: black;">&lt;30m</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">13%</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">50</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">32%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">40%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">30</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">19%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">30</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">60%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid black 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="92"><P><STRONG style="color: black;">31-60m</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">6%</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">43</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">27%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">23%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">33</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">21%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">33</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">77%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid black 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="92"><P><STRONG style="color: black;">1-2h</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">1%</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">47</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">30%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">4%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">45</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">28%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">45</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">96%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid black 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="92"><P><STRONG style="color: black;">&gt;2h</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">8%</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">18</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">11%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">Yes</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">67%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="87"><P align="center" style="text-align: center;"><SPAN style="color: black;">4%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">No</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="84"><P align="right" style="text-align: right;"><SPAN style="color: black;">33%</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>THANKS A LOT <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 23 Feb 2014 09:00:30 GMT https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620664#M1112440 2014-02-23T09:00:30Z Re: Merge Pivot tables together https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620665#M1112441 <HTML><HEAD></HEAD><BODY><P>If you could upload your sample file, will definitely try to help you.</P></BODY></HTML> Sun, 23 Feb 2014 19:38:04 GMT https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620665#M1112441 MK_QSL 2014-02-23T19:38:04Z Re: Merge Pivot tables together https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620666#M1112442 <HTML><HEAD></HEAD><BODY><P>sorry i cannot share the dash as it is confidential data. I guess the data presented to you us enough.</P><P>Especially for the formula part</P></BODY></HTML> Mon, 24 Feb 2014 16:12:56 GMT https://community.qlik.com/t5/QlikView/Merge-Pivot-tables-together/m-p/620666#M1112442 2014-02-24T16:12:56Z