topic pivot table calculation issues in QlikView https://community.qlik.com/t5/QlikView/pivot-table-calculation-issues/m-p/666014#M1078657 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I created a pivot but I couldnot able to get the exact result</P><P>can you guide me to get the exact one</P><P><IMG alt="pivottable.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62348_pivottable.png" style="width: 620px; height: 328px;" /></P><P>I am using the following expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Type</SPAN><SPAN style="font-size: 8pt;">,'Budget','Actuals'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Amount</SPAN><SPAN style="font-size: 8pt;">), '#,##0'), <BR /><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Sub_Region</SPAN><SPAN style="font-size: 8pt;">, 'SOUTH PACIFIC'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Sub_Region</SPAN><SPAN style="font-size: 8pt;">={'SOUTH PACIFIC'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Type</SPAN><SPAN style="font-size: 8pt;">={'Budget'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.PL</SPAN><SPAN style="font-size: 8pt;">={'MG','9R'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Amount</SPAN><SPAN style="font-size: 8pt;">/100), '#,##0%'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Amount</SPAN><SPAN style="font-size: 8pt;">)/100, '#,##0%')),<BR /><BR />&nbsp;&nbsp;&nbsp; <BR /><BR /> ) </SPAN></P><P> </P><P></P><P></P></BODY></HTML> Mon, 14 Jul 2014 07:01:35 GMT 2014-07-14T07:01:35Z pivot table calculation issues https://community.qlik.com/t5/QlikView/pivot-table-calculation-issues/m-p/666014#M1078657 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I created a pivot but I couldnot able to get the exact result</P><P>can you guide me to get the exact one</P><P><IMG alt="pivottable.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62348_pivottable.png" style="width: 620px; height: 328px;" /></P><P>I am using the following expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Type</SPAN><SPAN style="font-size: 8pt;">,'Budget','Actuals'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Amount</SPAN><SPAN style="font-size: 8pt;">), '#,##0'), <BR /><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Sub_Region</SPAN><SPAN style="font-size: 8pt;">, 'SOUTH PACIFIC'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Sub_Region</SPAN><SPAN style="font-size: 8pt;">={'SOUTH PACIFIC'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Type</SPAN><SPAN style="font-size: 8pt;">={'Budget'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.PL</SPAN><SPAN style="font-size: 8pt;">={'MG','9R'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Amount</SPAN><SPAN style="font-size: 8pt;">/100), '#,##0%'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ServiceOLR.Amount</SPAN><SPAN style="font-size: 8pt;">)/100, '#,##0%')),<BR /><BR />&nbsp;&nbsp;&nbsp; <BR /><BR /> ) </SPAN></P><P> </P><P></P><P></P></BODY></HTML> Mon, 14 Jul 2014 07:01:35 GMT https://community.qlik.com/t5/QlikView/pivot-table-calculation-issues/m-p/666014#M1078657 2014-07-14T07:01:35Z