Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Makedate in where

Hello,

I´ve a column with time value and i need load whole records that are before 14:00 pm.

I´m using it 

   but isn´t work.

Thank you

time( DT_EVENTO)  <= maketime(14,10,0)

1 Solution

Accepted Solutions
Not applicable

 

time( DT_OCORRENCIA ) <=  '$(vTime)PM'

View solution in original post

3 Replies
Champion
Champion

let vTime=MakeTime(10,20,30);

time( DT_EVENTO)  <=$( vTime) or '$( vTime)'

hope this helps

Hi

If u want the less than 14 hour means..simply u can hard code like it

Where

Hour(DI_Evento)   <= 14;

Hope it helps

Thanks & Regards,
Mayil Vahanan R
Not applicable

 

time( DT_OCORRENCIA ) <=  '$(vTime)PM'

View solution in original post