topic Show opening hours in map in QlikView

Show opening hours in map

Wed, 26 Mar 2014 12:46:51 GMT

Hello! I have a listbox with openingshours.

06.00-24.00

06.30-16.00

etc

I want to make a green/red light if the current store is open right now.

So i will make a Gauge chart and change the look.

But it is possible to read the current time and check if the store i open and then have a green/red light if it open or not?

Thanks!

Re: Show opening hours in map

Anonymous — Wed, 26 Mar 2014 14:07:15 GMT

Eric,

You can find current time using function now(), for example:

=timestamp(frac(now()), 'hh:mm:ss')

The problem with this approach is that the function checks time every second, hence consumes CPU. You can use it with the parameter:
now(2)
In this case it shows time of the document opening. No checking every second.

Regards,
Michael

Re: Show opening hours in map

Wed, 26 Mar 2014 14:13:29 GMT

Yes i have found that. But how can i compare the current timestamp i have it in HH:MM,

And now i want to se if that is between the list box i have, as example 07.00-16.00

Re: Show opening hours in map

ljackson — Wed, 26 Mar 2014 14:53:23 GMT

If it was me, I would separate the times so you have an opening time dimension, and a closing time dimension.

Then, in the visual cues, you could write an expression (maybe an IF function), saying if 'now' is bigger than opening time, and less than closing time show as green. If not show as red.

Re: Show opening hours in map

Thu, 27 Mar 2014 07:10:45 GMT

Ok! I can for sure separate the times. So i have two dimensions.

time(Now(1)) gives me the current time in HH:MM.

So how can i write a if statement to check if the currenttime is between opening and closing hour?

A big thank you!!

Re: Show opening hours in map

Thu, 27 Mar 2014 08:37:49 GMT

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

This is my guess, but that does not work

Re: Show opening hours in map

Anonymous — Thu, 27 Mar 2014 10:59:53 GMT

Logic is correct . It should work if the store is the dimension.

Can you upload an example of your application?

Re: Show opening hours in map

ThornOfCrowns — Thu, 27 Mar 2014 11:19:30 GMT

[MM] indicates a two-digit month of the year

[mm] refers to a zero-padded minute between 00 and 59

Re: Show opening hours in map

Thu, 27 Mar 2014 14:11:49 GMT

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

I know have this expression.

But i want the graph to show for PRU A and AREA B without any choices in the listboxes, But this does not work 😕

Re: Show opening hours in map

ljackson — Mon, 31 Mar 2014 12:39:21 GMT

I'm guessing a little bit now, as I can't access my QV at the moment to test it, but I would say you need a expression similar to this:

=time(

{$<Pru={'A'}, Area={'B'}>}

Frac(now(1))>Open AND time(Frac(now(1))<Close

)

The second line shows that for the selection, only show records where Pru=A and Area=B, from this data set the third line will calculate.

Hope that makes sense.