topic Electricity Usage - in QlikView

Electricity Usage -

Mon, 14 Nov 2011 16:26:29 GMT

Hello,

I have a variable electr_usage which shows the last exported meter figure of my electricity module.

Thus the variable accumulates every day.

I want a graph which shows the evolution of my usage per day.

So I need to take the current meter figure - the meter figure the day before.

I tried set analysis functions, but can't seem to get this working.

Can anyone else give it a try please?

I've attached a testfile...

Many Thanks!

Mon, 14 Nov 2011 16:41:17 GMT

Epression like:

electr_usage - above(electr_usage)

Stephen

Tue, 15 Nov 2011 08:02:55 GMT

Hi Stephen,

thanks for the reply.

but I guess this formula will only work when I have only 1 meter.

However, I have 30 meters.

So when analysing the meter usage of meter 30 it will probably do usage 30 - usage 29 instead of usage 30 today - usage 30 the day before....

Tue, 15 Nov 2011 09:37:17 GMT

The function is helpfull when unchecking the "allow interactive sort" of your chart.

It helps me out a bit,

however, I still don"t have all the flexibility in drawing my charts as I am used to.

Thanks a lot for the help though!