topic Re: Difference in fields in QlikView

Difference in fields

agsearle — Wed, 27 Jul 2011 13:47:51 GMT

I have a QVD with meter readings data in it. This is made up of one row for each reading, therefore each customer will have numerous rows of readings.

This data will have:

Customer Number - Reading Date - Meter Reading

1234 01/09/2010 100

1234 01/12/2010 110

1234 01/02/2011 135

I need to work out the difference between the last reading and the reading before, for each customer. So for the example above the difference would be 25. I can identify the latest reading by MAX(Meter Reading), but can't think how to subtract the second highest reading?

Can this be done in either the script or via an expression in a chart table?

Difference in fields

Wed, 27 Jul 2011 14:17:12 GMT

Hi,

You can do this using Peek() function in script. Peek function will not work in Charts.

- Sridhar

Re: Difference in fields

rahulgupta — Wed, 27 Jul 2011 14:19:23 GMT

Hey Hi,

Kindly Find the attached file for your solution.

Regards

Re: Difference in fields

richnorris — Wed, 27 Jul 2011 14:26:50 GMT

Pretty sure you can actually just subtract max(Meter reading, 2), max takes a parameter for the rank as well as for the data field.

Re: Difference in fields

agsearle — Wed, 27 Jul 2011 14:29:32 GMT

Of course. Didn't even think of that, works fine, thanks!