Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It all depends on where do you want the result to be displayed.
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?
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];
PFA
http://community.qlik.com/message/379372#379372
please refer the link above and help...
it is quite urgent