topic Re: Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689217#M249610 <HTML><HEAD></HEAD><BODY><P>Can you attach sample qvw</P></BODY></HTML> Thu, 09 Oct 2014 09:22:38 GMT anbu1984 2014-10-09T09:22:38Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689215#M249608 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following data in a <SPAN style="font-size: 10pt; line-height: 1.5em;">Pivot Table</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 419px;"><TBODY><TR><TD class="xl22" height="17" width="138">DESCRIPTION</TD><TD class="xl23" width="98">ACTUAL</TD><TD class="xl23" style="border-left: none;" width="98">BUDGET</TD><TD class="xl23" style="border-left: none;" width="85">DISCOUNTED</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">GROSS_PROFIT</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">183,737,772</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">232,613,759</TD><TD align="right" class="xl25" style="border-top: none; border-left: none;">202,521,006</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">TOTAL_EXPENSES</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">249,717,518</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">255,268,534</TD><TD align="right" class="xl25" style="border-top: none; border-left: none;">249,717,518</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">OTHER_INVEST_INCOME</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">39,947,666</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">57,896,825</TD><TD align="right" class="xl25" style="border-top: none; border-left: none;">50,406,834</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">NET_PROFIT</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">(26,032,081)</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">35,242,049</TD><TD align="right" class="xl26" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">30,682,859</SPAN></TD></TR></TBODY></TABLE><P>Expected Value(Gross_Profit-Total_Expenses+Other_Income) 3,210,332</P><P></P><P>I want to calculate the Value of Rs.3,210,332 instead of 30,682,859(highlighted in red)</P><P>Pls help me</P></BODY></HTML> Thu, 09 Oct 2014 06:24:49 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689215#M249608 upaliwije 2014-10-09T06:24:49Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689216#M249609 <HTML><HEAD></HEAD><BODY><P>Can someone pls help me to solve my issue</P></BODY></HTML> Thu, 09 Oct 2014 09:18:29 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689216#M249609 upaliwije 2014-10-09T09:18:29Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689217#M249610 <HTML><HEAD></HEAD><BODY><P>Can you attach sample qvw</P></BODY></HTML> Thu, 09 Oct 2014 09:22:38 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689217#M249610 anbu1984 2014-10-09T09:22:38Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689218#M249611 <HTML><HEAD></HEAD><BODY><P>Explain more or please provide sort sample file for this.</P></BODY></HTML> Thu, 09 Oct 2014 09:49:10 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/689218#M249611 its_anandrjs 2014-10-09T09:49:10Z