Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

is the store open? If-statements

Hello!

I just got some help, but i need some more

I have the following expression:

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

I have two list boxes also whitch show PRU and AREA.

I want to have several gauge chart showing the different PRU and AREAS and if they are open or not.

So i wanna have one for PRU A and AREA A, Then one for PRU A and AREA B etc.

I dont want to make any selection within this application. I want the user just to see if the store i open right now or not.

This does not work atm. If i choose PRU A and AREA B in the listbox i get the right answer (-1 for open and 0 for closed).

How can i get this to work?

Thanks!

10 Replies
Not applicable
Author

Found it, it was just an ( to much. I think you solution works. Will try a bit more!!!!