topic Re: time comparaison in QlikView

time comparaison

master_student — Fri, 23 Sep 2016 13:48:37 GMT

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

Re: time comparaison

jonathandienst — Fri, 23 Sep 2016 13:52:12 GMT

Didn't you post this same question earlier? Please don't duplicate your post - it creates clutter and confusion.

Re: time comparaison

sunny_talwar — Fri, 23 Sep 2016 13:52:41 GMT

Hi master_student‌ -

We understand that you are eager to find a solution, but opening multiple threads (one after the other) is not going to help. Use one thread and explain what exactly are you looking for, because until you do so, you won't find a solution and the community will be spammed by your multiple threads.

To me all these threads are asking for the same thing, isn't it?

time‌

maximum time‌

condition‌

Best,

Sunny

Re: time comparaison

master_student — Fri, 23 Sep 2016 13:53:15 GMT

no. it isn't the same pb

Re: time comparaison

el_aprendiz111 — Fri, 23 Sep 2016 14:00:33 GMT

1 example:

=IF(Frac(NOW())*100>=50,WeekDay(Today()),Year(Today()))

Re: time comparaison

miguelbraga — Fri, 23 Sep 2016 14:26:18 GMT

Hey there,

See this code:

if(

// Compare if the time from DATE_DEB

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

// is greater then

// 13:00:00

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

// if so, DATE_DEB

DATE_DEB,

// If not, null() value

null()

) as DATE

Best regards,

D.A. MB

Re: time comparaison

master_student — Fri, 23 Sep 2016 14:31:20 GMT

the result is like that 42432,2

Re: time comparaison

sunny_talwar — Fri, 23 Sep 2016 14:36:17 GMT

You need the time component only?

If(Time(Frac(TimeStamp#(DATE_DEB, 'DD/MM/YYYY hh:mm:ss'))) > MakeTime(13), Time(Frac(TimeStamp#(DATE_DEB, 'DD/MM/YYYY hh:mm:ss')))) as TIME

Re: time comparaison

miguelbraga — Fri, 23 Sep 2016 14:41:59 GMT

Try this:

if(

// Compare if the time from DATE_DEB

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

// is greater then

// 13:00:00

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

// if so, DATE_DEB

Date(DATE_DEB),

// If not, null() value

null()

) as DATE

Re: time comparaison

master_student — Fri, 23 Sep 2016 14:42:50 GMT

Hi Miguel,

Thank you for your reply. I appreciate your help.

I changed your code as follow :

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,

It works but I have a problem; whene I have more then one time>13 => I have to display the first one, any suggestions?

Re: time comparaison

miguelbraga — Fri, 23 Sep 2016 14:46:57 GMT

Try the Function -> firstsortedvalue().

See examples bellow:

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

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.h…

Hope it helps