Discussion board where members can get started with QlikView.
I need to count the ID that are into the followings diferents shifts:
Shift 1 6:00 to 14:00
Shift 2 14:00 to 22:00
Shift 3 22:00 to 6:00
My source is like:
I need count shift by shift (diferent count)
I'd create a shift field during the load of your data.
if(hour(Date)<6,1,if(hour(Date)<14,2,if(hour(Date)<22,3,1))) as Shift
Then use Shift as the dimension.