Discussion board where members can get started with Qlik Sense.
I have a column containing sensor values at the start of each month.
I want to obtain the difference between the sensor value of each month for each equipment.
The results should be as follows:
Does anyone know how to do this in the data load editor?
date#(month, 'MMM-YYYY') as month,
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);
If(equipment=peek(equipment), RangeSum(-[sensor value],peek([sensor value]))) as [monthly hours]
Resident t1 order by equipment, month Desc;
Drop Table t1;
View solution in original post
Thank you very much for your help Tresesco, that worked perfectly!