if statement with timestamps

qlikconsultant · ‎2013-01-17

I have the following data:

My goal is to get the sum over the next 10 minute of the timestamp.

Example: For 08.05.2012 17:42:54 the result should be 4.

My idea is:

sum(if(TIME_STAMP<=TIME_STAMP+7minute,Atribute A)) as mySum

But I have no idea for the code TIME_STAMP+7. Any ideas?

swuehl · ‎2013-01-17

Hi Markus,

I created a copy of your TIME_STAMP field in a data island to use as dimension, thus allowing something like

=sum(if( TIME_STAMP >= TIME_STAMP_DIM and TIME_STAMP <= TIME_STAMP_DIM + Interval#(10,'mm') , [Atribute A]))

See attached.

Regards,

Stefan

qlikconsultant · ‎2013-01-30

Hi swuehl,

I implemted your idea in my report but for some that I cant explain i get adition on the last row.

Is there any solution to calculate the value in the skript?

Related Topics