We are trying to create shift based reports.Ideally there will be 3 Shifts per day.I am trying to implement the logic as
Add an additional column to table where as it will have the data based on time if it falls 6.00 AM to 2:00 PM as Shift 1,2 :00PM to 10:00 PM second Shift. And 10:00-6:00 as third shift.
Please suggest ......Is there any other way since the calender in QlikView doestnt support choosing the Time.
