topic Re: wierd output using above in QlikView

wierd output using above

t_hylander — Tue, 08 Mar 2016 12:40:02 GMT

Hi,

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.

m_woolf — Tue, 08 Mar 2016 18:57:44 GMT

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.

swuehl — Tue, 08 Mar 2016 19:04:12 GMT

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))

t_hylander — Wed, 09 Mar 2016 06:51:40 GMT

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

jagan — Wed, 09 Mar 2016 07:03:55 GMT

Hi,

I think the numbers seems to be correct, you can limit the numbers to two digits in the number tab.

Regards,

Jagan.

jagan — Thu, 10 Mar 2016 00:56:29 GMT

HI,

If you got the answer close this thread by giving Correct and Helpful answers to the post which helps you in finding the answer.

Regards,

Jagan.