Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Data Calculation

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

5 Replies
MVP
MVP

Re: Data Calculation

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
Not applicable

Re: Data Calculation

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?

Not applicable

Re: Data Calculation

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

MVP
MVP

Re: Data Calculation

PFA

Not applicable

Re: Data Calculation

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

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

Community Browser