topic Re: subtracting data from two dates in QlikView

subtracting data from two dates

Wed, 25 Sep 2013 05:42:43 GMT

Hi,

I have cumulative data.I want to get the actual data by subtracting data from two dates.

Ex.Date Power Actual Power

1/08/2013 11000 11500-11000=500

2/8/2013 11500 12000-11500=500

3/8/2013 12000 Data from 4/8/2013-12000

I am plotting a chart for the same.

I have used

only({<Billing_DAY={$(=Only(Billing_DAY))}>} Billing_KWH_FWD) - only({<Billing_DAY={$(=Only(Billing_DAY-1))}>} Billing_KWH_FWD)

But it is not working.

Thanks

Asmita

Wed, 25 Sep 2013 05:57:06 GMT

Hi,

PFA

jagan — Wed, 25 Sep 2013 05:59:08 GMT

Hi Asmita,

You can do this in script by using the below script

LOAD

If(RowNo() <> 1, Previous(Power) - Power, Power) AS [Actual Power]

FROM TableName

Order by Date Desc;

Regards,

Jagan.

Wed, 25 Sep 2013 06:24:39 GMT

use this expression

below(Power,1)-Power

below(power)-power

in ur chart expression

Thu, 26 Sep 2013 04:20:51 GMT

Hi Jagan,

I also want to subtract next record from today's record.

Kushal_Chawda — Thu, 26 Sep 2013 05:58:20 GMT

see the attached one

jagan — Thu, 26 Sep 2013 06:41:12 GMT

Hi,

I didn't get you, can you come up with some sample data.

Regards,

Jagan.