Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Calculation problems in a Chart

I have a small problem where the above image is correct and the chart below is wrong.  The column labeled Projected 2014 should match on both.  I am using an InputSum with a variable on the top for the What If column (all calculations on the top are correct).  The bottom chart I use the same calculation however it's doing the calculation on the total line also.  Is there a way to only use the detail lines for the chart and ignore the total?

Here is the calculation I am using on both:

sum({} [In company code currency_HSL]  * -1)  + sum({} [In company code currency_HSL] * -1)             * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)             * InputSum(vPCT) +  sum({} [In company code currency_HSL] * -1)            * InputSum(vPCT) +  sum({} [In company code currency_HSL] * -1)                * InputSum(vPCT) +    sum({} [In company code currency_HSL] * -1)               * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)               * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)          * InputSum(vPCT) +   sum({} [In company code currency_HSL] * -1)      * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)          * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)    * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1)             * InputSum(vPCT) +   sum({} [In company code currency_HSL] * -1)      * InputSum(vPCT)

P3.pngP4.png

0 Replies