Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Using condition to warn/suggest user

Hi all,

I am trying to create the condition to check the shift of workers. If the worker who has name on that shift shouldn't taking care more than one room on the that shift. And worker cannot work for 24 hours, they can work 2 shifts on the same day or 2 days like Noon and Midnight shift. Each condition can be separate. Is that possible?


I also attach qvf file with this post.

Thanks in advance

Labels (1)
1 Reply
Partner - Contributor III
Partner - Contributor III

Any Suggestion?

I am trying to use this condition

=If(Date_1 = Date(Date(Date_1)),
If(Shift = Shift,
If(Count(Total ID) > 2, 'Good', 'Bad')))

But all result show as "Good". It cannot show who has the shift and got 2 rooms as "Bad". Where do I miss?

**I change Date field name into Date_1**