Data Calculation

[#1]

Good Day Community,

I would like to know how would i go about working out the difference between two days data eg. if 1/6/2013 = 200 and if  2/6/2013 =250 i would like to know how would i go about scripting, ( 250 - 200 = 50) as i require that value of 50.

Is it also possible to loop it so that it works out it out for the next dates and so fort?

Thank You Kindly

SR

[tresB]

It all depends on where do you want the result to be displayed.

• You can do it in the script
• You can do it in a chart/table (at the front end) - sort the table and use above()/below() functions

[#3]

Hi Tres,

I would like to do it in a Table/Chart... could you possibly assist me with the code to go about working it out?

[#4]

Hi,

Use Previous() function if you need to calculate previous record data.

Ex:

Load Date,

     Data,

Data-Previous(Data) as Difference;

Load Date, Data from [location of file];

[tresB]

PFA

[#6]

http://community.qlik.com/message/379372#379372

please refer the link above and help...
it is quite urgent