Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Time Comparison in IF condition

Hi Experts,

How do i compare a time in If condition i.e.

I have a DocCreateTime field (carrying just time with format: 11:05:30AM ) coming from database. I just want records, having time value lesser than 10:00:00AM.

How do i do that ?

Help Required please!

1 Reply
dineshraj
Contributor

Re: Time Comparison in IF condition

Hi Shazad,

I think this may help you

Let vTime='10:00:00AM'

And in Load script with where condition

where DocCreateTime <'$(vTime)'


Thanks

Community Browser