topic Re: If statement problem. in QlikView

If statement problem.

Thu, 27 Mar 2014 09:47:38 GMT

Hi!

I have 2 listboxes with timestamps, HH:MM. Open and Close.

I want to check the current time to see if the store is open and or closed. So i want to return a 0 or 1.

This is my expression: if(time(now(1))>Open AND time(now(1))<Close, 1, 0)

But it does not work.

It shows 0 when the open is 11:00 and close is 23:00 and now the time(now) = 10:47

Thanks!!

Re: If statement problem.

jonathandienst — Thu, 27 Mar 2014 09:53:17 GMT

The expression looks OK, but it will only work in a chart/table expression or you have made selections so that no more than 1 possible open and close value (for each row in a chart).

HTH

Jonathan

Re: If statement problem.

jsingh71 — Thu, 27 Mar 2014 09:53:29 GMT

Can you let me know, In which format you are having Open and Close Time.

Re: If statement problem.

jsingh71 — Thu, 27 Mar 2014 09:54:30 GMT

And also can you share some sample data.

--Jai

Re: If statement problem.

tresB — Thu, 27 Mar 2014 09:56:29 GMT

Are you considering A.M/P.M in now()?

Re: If statement problem.

CELAMBARASAN — Thu, 27 Mar 2014 10:01:34 GMT

You cann't use Time as it is

if(time(Frac(now(1)))>Open AND time(Frac(now(1)))<Close, 1, 0)

Becuase Time function internally it keeps the date value too.

If this didn't works, could you please tell how your storing the time range in Open and Close?

Re: If statement problem.

Thu, 27 Mar 2014 11:20:06 GMT

That works! Thanks!

Re: If statement problem.

Thu, 27 Mar 2014 11:20:23 GMT

No since im living in Sweden we don't use AM/PM

Re: If statement problem.

Thu, 27 Mar 2014 11:20:35 GMT

HH:MM

Re: If statement problem.

Thu, 27 Mar 2014 11:26:57 GMT

One more question.

I have the 2 listboxes with PRU and AREA.

If i want a chart to show if(time(Frac(now(1)))>Open AND time(Frac(now(1)))<Close, 0, 1) but only for PRU A and AREA A how can i hardcode this into my if statement?

Thanks!

Re: If statement problem.

CELAMBARASAN — Thu, 27 Mar 2014 11:30:01 GMT

Write a condition in the chart properties as

=time(Frac(now(1)))>Open AND time(Frac(now(1)))<Close and PRU = 'A' AND AREA = 'A'

Re: If statement problem.

Thu, 27 Mar 2014 11:31:52 GMT

I still want it to return 0 or 1