Discussion Board for collaboration on QlikView Scripting.
I've got several meter readings and wish to calculate the diffrence with current and last read reading.
When using above in a expression "sum(varde) / above(sum(varde))", I get wierd sums. What is it Im missing?
See the picture for example.
I didn't bother checking, but the sums look approximately correct to me.
for row 2, the sum is 44910.3. the sum(above) is 44843.9. If you divide those numbers, the answer should be slightly larger than 1.
The numbers seem correct to me,too. What do you expect to see / why do you think the numbers are weird?
If you want to calculate the difference, use
sum(varde) - above(sum(varde))
argh, crap...cant work on several projects at the same time.
Of course it looks wierd when you use the wrong calculation.
yes, its subtraction Im after, I mixed it up with another chart, shame on me.
thanks for clearing that out
I think the numbers seems to be correct, you can limit the numbers to two digits in the number tab.
If you got the answer close this thread by giving Correct and Helpful answers to the post which helps you in finding the answer.