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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
0 Replies