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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!!!!