topic Calculation problems in a Chart in QlikView https://community.qlik.com/t5/QlikView/Calculation-problems-in-a-Chart/m-p/643662#M235830 <HTML><HEAD></HEAD><BODY><P>I have a small problem where the above image is correct and the chart below is wrong.&nbsp; The column labeled Projected 2014 should match on both.&nbsp; I am using an InputSum with a variable on the top for the What If column (all calculations on the top are correct).&nbsp; The bottom chart I use the same calculation however it's doing the calculation on the total line also.&nbsp; Is there a way to only use the detail lines for the chart and ignore the total?</P><P></P><P>Here is the calculation I am using on both: </P><P></P><P></P><P>sum({} [In company code currency_HSL]&nbsp; * -1)&nbsp; + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp;&nbsp;&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp;&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp;&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) </P><P><IMG __jive_id="59406" alt="P3.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59406_P3.png" style="width: 620px; height: 173px;" /><IMG __jive_id="59405" alt="P4.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59405_P4.png" style="width: 620px; height: 311px;" /></P></BODY></HTML> Thu, 22 May 2014 14:33:03 GMT tmumaw 2014-05-22T14:33:03Z Calculation problems in a Chart https://community.qlik.com/t5/QlikView/Calculation-problems-in-a-Chart/m-p/643662#M235830 <HTML><HEAD></HEAD><BODY><P>I have a small problem where the above image is correct and the chart below is wrong.&nbsp; The column labeled Projected 2014 should match on both.&nbsp; I am using an InputSum with a variable on the top for the What If column (all calculations on the top are correct).&nbsp; The bottom chart I use the same calculation however it's doing the calculation on the total line also.&nbsp; Is there a way to only use the detail lines for the chart and ignore the total?</P><P></P><P>Here is the calculation I am using on both: </P><P></P><P></P><P>sum({} [In company code currency_HSL]&nbsp; * -1)&nbsp; + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp;&nbsp;&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp;&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp; * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) +&nbsp;&nbsp; sum({} [In company code currency_HSL] * -1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * InputSum(vPCT) </P><P><IMG __jive_id="59406" alt="P3.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59406_P3.png" style="width: 620px; height: 173px;" /><IMG __jive_id="59405" alt="P4.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59405_P4.png" style="width: 620px; height: 311px;" /></P></BODY></HTML> Thu, 22 May 2014 14:33:03 GMT https://community.qlik.com/t5/QlikView/Calculation-problems-in-a-Chart/m-p/643662#M235830 tmumaw 2014-05-22T14:33:03Z