topic Re: Staff Roster Chart in QlikView

Staff Roster Chart

vardhancse — Thu, 10 May 2018 07:54:49 GMT

Hi,

Have a requirement to build a chart based on attached excel sheet.

Data: Raw Data (sheet name)

Chart: Chart (sheet name)

can please help me out to achieve the same.

Please not e we have some staff coming like 8:30 to 17:30 as well so we need to display the in chart as well

duncanblaine — Thu, 10 May 2018 08:30:23 GMT

See attached.
I haven't added days in, but should be easy enough.

Create a bar chart with Stacked style,

then have 3 Expressions:

Details in the QVW

vardhancse — Thu, 10 May 2018 09:04:30 GMT

Hi,

thank you so much

All good and as expected , but one issue is that if staff roster details are from evening to early morning then graph is little bit odd.

PFA updated QVW, once can please have a look

duncanblaine — Fri, 11 May 2018 00:22:48 GMT

Hi Varaha
To add in night shifts we just need to adjust the Expressions a bit and add an extra one.
See attached app

gantt‌ gantt chart‌ roster‌

vardhancse — Fri, 05 Oct 2018 05:38:44 GMT

to same chart, now need timezone conversion like SGT, AUS, UK & USA.

Would you be able to help me out