topic Pivot table grouping issue in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1323417#M409723 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have a small issue with pivot table, i am use two expressions like actual and actual%. if i select period 1 actual and actual percentage displays perfect, if i select period 1,2,3, actual displays perfect but actual% not displays right values following is attachment</P><P></P><P>period 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actual%</P><P>------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----------</P><P>Gross Revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P></P><P></P><P></P><P><SPAN style="color: #000000;">Period 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">actual</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">actual%</SPAN> </SPAN><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">actual</SPAN><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">actual%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">actual</SPAN><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">actual%</SPAN><SPAN style="font-size: 13.3333px;"> </SPAN></SPAN></P><P><SPAN style="color: #000000;">-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</SPAN></P><P><SPAN style="font-size: 13.3333px; color: #000000;">Gross Revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">31%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Gross Revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">&nbsp; 33%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Gross Revenue&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">33%</SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px;"><SPAN style="color: #000000;">i want each actuals also 100% please assist me </SPAN><BR /></SPAN></P></BODY></HTML> Wed, 26 Apr 2017 12:59:54 GMT 2017-04-26T12:59:54Z Pivot table grouping issue https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1323417#M409723 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have a small issue with pivot table, i am use two expressions like actual and actual%. if i select period 1 actual and actual percentage displays perfect, if i select period 1,2,3, actual displays perfect but actual% not displays right values following is attachment</P><P></P><P>period 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actual%</P><P>------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----------</P><P>Gross Revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P></P><P></P><P></P><P><SPAN style="color: #000000;">Period 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">actual</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">actual%</SPAN> </SPAN><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">actual</SPAN><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">actual%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">actual</SPAN><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">actual%</SPAN><SPAN style="font-size: 13.3333px;"> </SPAN></SPAN></P><P><SPAN style="color: #000000;">-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</SPAN></P><P><SPAN style="font-size: 13.3333px; color: #000000;">Gross Revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">31%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Gross Revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">&nbsp; 33%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Gross Revenue&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">33%</SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px;"><SPAN style="color: #000000;">i want each actuals also 100% please assist me </SPAN><BR /></SPAN></P></BODY></HTML> Wed, 26 Apr 2017 12:59:54 GMT https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1323417#M409723 2017-04-26T12:59:54Z Re: Pivot table grouping issue https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1323418#M409724 <HTML><HEAD></HEAD><BODY><P>this is my expression</P><P></P><P><IMG alt="exp.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161343_exp.jpg" style="height: 373px; width: 620px;" /></P></BODY></HTML> Wed, 26 Apr 2017 13:35:55 GMT https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1323418#M409724 2017-04-26T13:35:55Z