topic Re: if condition not working in QlikView

if condition not working

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Re: if condition not working

ahaahaaha — Thu, 12 Jan 2017 16:56:53 GMT

Try

if(DeliveryTime >= Date('10:00:00') and DeliveryTime <= Date('15:00:00') ,1,0) as Flag.

Re: if condition not working

trdandamudi — Thu, 12 Jan 2017 16:58:46 GMT

Your line of code should work, I just tried and it works:

if(DeliveryTime >= '10:00:00' and DeliveryTime <= '15:00:00' ,1,0) as Flag

Re: if condition not working

Thu, 12 Jan 2017 17:02:20 GMT

why should i use Date() here?

Re: if condition not working

Thu, 12 Jan 2017 17:02:40 GMT

its not working

Re: if condition not working

ahaahaaha — Thu, 12 Jan 2017 17:04:05 GMT

overworked 🙂

if(DeliveryTime >= Time('10:00:00') and DeliveryTime <= Time('15:00:00') ,1,0) as Flag.

Re: if condition not working

trdandamudi — Thu, 12 Jan 2017 17:06:14 GMT

I used the following sample code and it works:

Data:

Load *,

if(DeliveryTime >= '10:00:00' and DeliveryTime <= '15:00:00' ,1,0) as Flag;

LOAD * INLINE [

Product,Color,SoldQty,DeliveryTime

70060306, BLACK, 58,10:00:00

70060306, BURGUN, 37,20:00:00

70060306, MULTI, 18,20:00:00

70380479, BLACK, 35,20:00:00

70380479, BROWN, 35,20:00:00

70380479, PINK, 13,20:00:00

60190130, BLACK, 22,20:00:00

60190130, NUDE, 35,20:00:00

60190130, WHITE, 15,20:00:00

70480047, BLACK, 45,20:00:00

70480047, SILVER, 16,11:00:00

70480047, WHITE, 8,15:00:00

60360830, BLACK, 40,20:00:00

60360830, NAVY, 12,20:00:00

60360830, PINK, 16,20:00:00

];

Re: if condition not working

sorrakis01 — Thu, 12 Jan 2017 17:06:20 GMT

Hi,

How is the format of DeliveryTime in the script or in the original data?

Regards

Re: if condition not working

Thu, 12 Jan 2017 17:07:20 GMT

no not working

Re: if condition not working

Thu, 12 Jan 2017 17:07:51 GMT

it is hh:mm:ss format

Re: if condition not working

sorrakis01 — Thu, 12 Jan 2017 17:11:52 GMT

Can you upload an example? or try this Time#(DeliveryTime,'hh:mm:ss') as DeliveryTime

Re: if condition not working

Fri, 13 Jan 2017 09:48:15 GMT

what should i use if i have time in this format

42747.582638889

Re: if condition not working

sorrakis01 — Fri, 13 Jan 2017 10:12:05 GMT

Hi Pr,

This is your format? Wich is the original data? Oracle? Unix? It's a concatenate field?

Regards

Re: if condition not working

Fri, 13 Jan 2017 10:22:36 GMT

yes. this is my format. data is from sql

Re: if condition not working

sunny_talwar — Fri, 13 Jan 2017 10:31:07 GMT

May be this:

If(Frac(DeliveryTime) >= MakeTime(10) and Frac(DeliveryTime) <= MakeTime(15), 1, 0) as Flag.

Re: if condition not working

susovan — Fri, 13 Jan 2017 10:33:26 GMT

You can also try this process ,

Time:

LOAD Time as @_Time

FROM

Table3.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD *,

if(Timestamp(@_Time,'hh:mm:ss')='10:00:00' and @_Time,'hh:mm:ss')='15:00:00',1,0) as @_Time_Flag

Resident Time;

Re: if condition not working

Fri, 13 Jan 2017 11:37:08 GMT

no sunny.

Not working.

I have attached sample data.

Please help

Re: if condition not working

Fri, 13 Jan 2017 11:37:28 GMT

its not working

Re: if condition not working

sunny_talwar — Fri, 13 Jan 2017 11:41:09 GMT

Seems to be working for me

Table:

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

FROM

[..\..\Downloads\Time test.xls]

(biff, embedded labels, table is Sheet1$);

Re: if condition not working

annafuksa1 — Fri, 13 Jan 2017 12:10:25 GMT

Please check my app