topic Re: Fix a value in QlikView

Fix a value

Anonymous — Tue, 10 Jul 2012 15:32:56 GMT

Hi everybody.

My script is

LOAD DEVICE,

MAX(`ENERGY`) AS MAX_MONTH,

MIN(`ENERGY`) AS MIN_MONTH,

Month(DATETIME) AS MONTH,

Year(DATETIME) AS YEAR,

RESIDENT DATA

GROUP BY IDPARK,IDDEVICE,Month(DATETIME),Year(DATETIME);

I need the SUM of (MAX_MONTH-MIN_MONTH) for each DEVICE in the current month.

I create a graph, put as Dimension : MakeDate(Year(now()),Month(now())

and the expression : sum(MAX_MONTH - MIN_MONTH)

but doesn't work...any help ?

The problem is linked to the dimension because i already used the expression in another graph "month by month" and works

somenathroy — Tue, 10 Jul 2012 16:14:11 GMT

Hi,

You can try the following:

put DEVICE as dimension use sum({<YEAR={'$(=year(today()))'}, MONTH={'$(=month(today()))'}>} MAX_MONTH- MIN_MONTH) as EXPRESSION.

Regards,

Som

Anonymous — Wed, 11 Jul 2012 10:14:33 GMT

I need the total sum of the devices, not the sum of each device.

i wrote badly, my mistake.

somenathroy — Wed, 11 Jul 2012 15:49:58 GMT

In that case put YEAR and MONTH in dimension list and use the same expression mentioned in my previous post.