Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Makedate in where

 

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

3 Replies
chauhans85
Esteemed Contributor

Re: Makedate in where

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

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

hope this helps

Re: Makedate in where

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

Not applicable

Re: Makedate in where

 

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

Community Browser