topic Re: Pivot table grouping issue in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327918#M842254 <HTML><HEAD></HEAD><BODY><P>then if u find any solution please assist am stuck there</P></BODY></HTML> Thu, 27 Apr 2017 08:59:01 GMT 2017-04-27T08:59:01Z Pivot table grouping issue https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327916#M842252 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have small issue with pivot table please assist me,</P><P></P><P>i have a two expressions like "actual" and "actual%". and i my dimension "Period".</P><P></P><P>if i select Period 1 the following data is displaying</P><P></P><P>&nbsp; <SPAN style="color: #00ff00;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #339966;">&nbsp; Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Actual%</SPAN></SPAN></P><P></P><P><SPAN style="color: #339966;">Gross revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp; 100000</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</SPAN></P><P></P><P></P><P>if i select Period 1,2,3 at a time with list box filter the following values are displaying.</P><P></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period1&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; <SPAN style="color: #ff0000;">Actual%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period2&nbsp;&nbsp;&nbsp; Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">Actual%&nbsp;&nbsp;&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period3&nbsp;&nbsp;&nbsp; Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">&nbsp; Actual%</SPAN></SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;">Gross revenue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp; 100000</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">31.08%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">34.01%</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1400000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">34.91%</SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #000000;">I want to display actual% also 100% each period like the following</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #00ff00;"><SPAN style="color: #339966;">&nbsp; Period1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> <SPAN style="color: #008000;">Actual%</SPAN><SPAN style="color: #008000;"> </SPAN><SPAN style="color: #339966;"><SPAN style="color: #008000;"> </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period2&nbsp;&nbsp;&nbsp; Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"><SPAN style="color: #339966;">Actual% </SPAN> </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period3&nbsp;&nbsp;&nbsp; Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #008000;">&nbsp; Actual%</SPAN></SPAN></SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;">Gross revenue&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">&nbsp; 100000</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #339966;">100%</SPAN><SPAN style="color: #339966;">&nbsp;&nbsp;&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #339966;">100%</SPAN><SPAN style="color: #339966;"> </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1400000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #339966;">100%</SPAN></SPAN></P><P><SPAN style="color: #ff0000;"> <BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #339966;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327916#M842252 2020-11-25T16:16:04Z Re: Pivot table grouping issue https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327917#M842253 <HTML><HEAD></HEAD><BODY><P>Please avoid double postings!</P><P></P><P><A href="https://community.qlik.com/thread/258498">Pivot table issue</A></P></BODY></HTML> Thu, 27 Apr 2017 08:48:47 GMT https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327917#M842253 Frank_Hartmann 2017-04-27T08:48:47Z Re: Pivot table grouping issue https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327918#M842254 <HTML><HEAD></HEAD><BODY><P>then if u find any solution please assist am stuck there</P></BODY></HTML> Thu, 27 Apr 2017 08:59:01 GMT https://community.qlik.com/t5/QlikView/Pivot-table-grouping-issue/m-p/1327918#M842254 2017-04-27T08:59:01Z