Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to make a coloured monthchart/pivot for absence from work

Hi

A time ago I came across a picture that shows a chart with abcence from work in a PA-app in qv. I have now been trying to do the same but don´t succed. I have uniq personID and hours of absence. Also start and stop date for the absence.

Can someone help me, or maybe someone have a demo with something similar. I guess it also can be used to show days a frontend-support are most busy, or when there are most customers bying stuff and so on. But I can´t find any demo, maybe i don´t know what terms I should search for.

The chart use dimensions YearMonth and on the top it´s Day of the month, in the colured coulmns it´s the dayname that are shown (swedish in this pic)

absence.JPG

Any suggestion?

1 Reply
Not applicable

Re: How to make a coloured monthchart/pivot for absence from work

Hi,

Perhaps, you can try this:

Create a straight table/pivot table and add the expression for Absent hours, expand it and add something like the following as background color.

=if(sum(Abs_WeekHrs)>0,LightRed(),Green())

Please check the attachment for a sample.

Hope it helps.

Regards,

-Khaled