This content has been marked as final. Show 2 replies
If you're brand new to QlikView this is a nice example.
Once you have built your script, I would:
- work out how to put it into a Table object - that way you can explore all the data visually, and is fairly easy
- next do something similar with a table in a Chart object - this gives much more flexibility and you can add expressions
- you are likely to need expressions which work out the total time worked each day, also you might want to have an expression for the time slot the start (and end) times are in eg. 7:30 - 8:00 am.
- after that, explore the different chart types - for example, you may need to build a chart which compares hours worked with start time (if someone starts later do they work fewer hours?)
Hope that helps.