topic Re: Problem with Pivot table in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241572#M394248 <HTML><HEAD></HEAD><BODY><P>It is OK: I have problem in my Set analyse. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 20 Mar 2017 13:43:23 GMT jozisvk11 2017-03-20T13:43:23Z Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241569#M394245 <HTML><HEAD></HEAD><BODY><P>I have table :</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE><TBODY><TR><TD>Divison</TD><TD>Fin. Mounth</TD><TD>Revenues</TD></TR><TR><TD>ABA</TD><TD>Jan</TD><TD>740 123 €</TD></TR><TR><TD>ABA</TD><TD>Feb</TD><TD>1 013 241 €</TD></TR><TR><TD>ABA</TD><TD>Mar</TD><TD>232 803 €</TD></TR><TR><TD></TD><TD>Jan</TD><TD>740 123 €</TD></TR><TR><TD></TD><TD>Feb</TD><TD>1 013 241 €</TD></TR><TR><TD></TD><TD>Mar</TD><TD>232 803 €</TD></TR></TBODY></TABLE><P>And I don´t know, why show me sum of rows. I need only first 3 rows.</P><P></P><TABLE style="font-size: 13.3333px;"><TBODY><TR><TD>Divison</TD><TD>Fin. Mounth</TD><TD>Revenues</TD></TR><TR><TD>ABA</TD><TD>Jan</TD><TD>740 123 €</TD></TR><TR><TD>ABA</TD><TD>Feb</TD><TD>1 013 241 €</TD></TR><TR><TD>ABA</TD><TD>Mar</TD><TD>232 803 €</TD></TR></TBODY></TABLE><P></P><P>Could you help me ? Thank you. </P></BODY></HTML> Mon, 20 Mar 2017 13:17:52 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241569#M394245 jozisvk11 2017-03-20T13:17:52Z Re: Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241570#M394246 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a screenshot of what you are seeing?</P></BODY></HTML> Mon, 20 Mar 2017 13:19:03 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241570#M394246 sunny_talwar 2017-03-20T13:19:03Z Re: Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241571#M394247 <HTML><HEAD></HEAD><BODY><P>May be use this in pivot expression</P><P></P><P><STRONG>Num(Sum({&lt;Divison <SPAN style="color: #ff0000; font-size: 14pt;">-</SPAN>= {'$(=If(Len(Division)&gt;0))'}&gt;}Revenues),'#,##0.00€')</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156849_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 20 Mar 2017 13:35:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241571#M394247 Anil_Babu_Samineni 2017-03-20T13:35:54Z Re: Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241572#M394248 <HTML><HEAD></HEAD><BODY><P>It is OK: I have problem in my Set analyse. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 20 Mar 2017 13:43:23 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241572#M394248 jozisvk11 2017-03-20T13:43:23Z Re: Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241573#M394249 <HTML><HEAD></HEAD><BODY><P>yes, it is OK <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 20 Mar 2017 13:43:49 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241573#M394249 jozisvk11 2017-03-20T13:43:49Z Re: Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241574#M394250 <HTML><HEAD></HEAD><BODY><P>If you solve your issue, You may close this thread by flag "<STRONG>Correct Answer</STRONG>"</P></BODY></HTML> Mon, 20 Mar 2017 14:39:46 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/1241574#M394250 Anil_Babu_Samineni 2017-03-20T14:39:46Z