topic Re: Data Calculation in QlikView

Data Calculation

Fri, 16 Aug 2013 07:17:10 GMT

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

Re: Data Calculation

tresB — Fri, 16 Aug 2013 07:23:05 GMT

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

Re: Data Calculation

Fri, 16 Aug 2013 07:27:16 GMT

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?

Re: Data Calculation

Fri, 16 Aug 2013 07:28:24 GMT

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];

Re: Data Calculation

tresB — Fri, 16 Aug 2013 07:37:31 GMT

PFA

Re: Data Calculation

Fri, 16 Aug 2013 07:39:34 GMT

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

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