Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
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]))
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?