This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I m trying to write if condition for a time like below in the script
if(DeliveryTime >= '10:00:00' and DeliveryTime <= '15:00:00' ,1,0) as Flag.
but this is not working. Is anything wrong in the expression?
Can someone please help
Can you upload an example? or try this Time#(DeliveryTime,'hh:mm:ss') as DeliveryTime
what should i use if i have time in this format
This is your format? Wich is the original data? Oracle? Unix? It's a concatenate field?
yes. this is my format. data is from sql
May be this:
If(Frac(DeliveryTime) >= MakeTime(10) and Frac(DeliveryTime) <= MakeTime(15), 1, 0) as Flag.
You can also try this process ,
LOAD Time as @_Time
(ooxml, embedded labels, table is Sheet1);
if(Timestamp(@_Time,'hh:mm:ss')='10:00:00' and @_Time,'hh:mm:ss')='15:00:00',1,0) as @_Time_Flag
I have attached sample data.
its not working
Seems to be working for me
LOAD [Delivery Id],
TimeStamp([Delivery Time]) as [Delivery Time],
If(Frac([Delivery Time]) >= MakeTime(10) and Frac([Delivery Time]) <= MakeTime(15), 1, 0) as Flag
(biff, embedded labels, table is Sheet1$);
View solution in original post
Please check my app