May be like this in the script:
Table:
LOAD Hour,
Current
FROM
[https://community.qlik.com/thread/218744]
(html, codepage is 1252, embedded labels, table is @1);
FinalTable:
LOAD Hour,
Current,
Num(Peek('Current') - Current) as Diff
Resident Table
Order By Hour desc;
DROP Table Table;
I am going to offer a slight modification to Stefan's solution (and I am sure he would approve the changes I propose)
(Below(Sum({1}Current)) * Avg(1)) - Sum(Current)
or
(Below(Sum({<Hour>}Current)) * Avg(1)) - Sum(Current)
This will help if you plan to make selection in the Hour field.
When no selections are made:
When single hour is selected:
When hours are selected continuously (14,15,16,17):
When non continuous hours are selected (13, 15, 17):
So if you don't plan to make selections in hour field, you might be good with what Stefan provided. But if you plan to make selection in Hour, then you might want to make the above modifications.
