Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jtovarsanchez
New Contributor II

How can I compare the time of a date

I did the following


if(TimeStamp(LlegaCarga,'hh:mm:ss')>'18:00:00','M','N')

1 Solution

Accepted Solutions
MVP
MVP

Re: How can I compare the time of a date

Perhaps this?

if(frac(LlegaCarga)>maketime(18),'M','N')

3 Replies
MVP
MVP

Re: How can I compare the time of a date

Perhaps this?

if(frac(LlegaCarga)>maketime(18),'M','N')

Re: How can I compare the time of a date

or

if (frac(LlegaCarga) > 0.75, 'M', 'N')

relying on the fact that 6pm or 1800hrs is 3/4 of a single day.

MVP
MVP

Re: How can I compare the time of a date

Or almost like you had it. I think this works, but I'm less confident in it.

if(text(timestamp(LlegaCarga),'hh:mm:ss'))>'18:00:00','M','N')