Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
t_hylander
New Contributor III

wierd output using above

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.

above.PNG

Tags (2)
5 Replies
mwoolf
Honored Contributor II

Re: wierd output using above

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.

MVP
MVP

Re: wierd output using above

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
New Contributor III

Re: wierd output using above

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

MVP
MVP

Re: wierd output using above

Hi,

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

Regards,

Jagan.

MVP
MVP

Re: wierd output using above

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.

Community Browser