time comparaison

[master_student]

Hello everyone,

I need to display the first time after 13:00:00

with this script, I only display all timings after 13h

if(

                         // Compare if the time from DATE_DEB

                         time(DATE_DEB,'DD/MM/YYYY hh:mm:ss')

                         // is greater then

                         >

                         // 13:00:00

                        time(date(floor(DATE_DEB) ,'DD/MM/YYYY') + time(MakeTime(13),'hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') ,

                         // if so, DATE_DEB

                        time(DATE_DEB),

                         // If not, null() value

                        null()

                 )  as DATEE,

DATE_DEB has this format : 12/05/2015 13:00:00

Ce message a été modifié par : master student

[miguelbraga]

Try the Function -> firstsortedvalue().

See examples bellow:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/AggregationFunctions/firstsor...

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFunction...

Hope it helps