Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER

Pivot Table Calendar - Displaying employee and national holidays

Not applicable

Pivot Table Calendar - Displaying employee and national holidays

Hi all,

I recently had the necessity to create a visual calendar on qlikview to see at a glance the employees on holidays.

I did not find much on the web, so I just wanted to share this job (not difficult but a bit tricky).

These are the main features:

- Based on a pivot table, a calendar displays the week days with the day number and the names of the employees on holidays

- Since it is just a table, you can filter it by any dimension and display for instance just the employees of Group A

- Saturdays and Sundays have a darker background

- National holidays (specified in the script) are highlighted in red

- The background changes from greenish to reddish depending on how many employees are on holidays

Any advice/suggestion to improve it is very welcome!

Regards

-Carlos

Tags (1)
Attachments
Comments
Contributor III
Contributor III

Nice example, Thanks.

Here is work around for English month.

Master_Calendar:

LOAD Date_Tmp as Event_Dates,

       Week(Date_Tmp) as Week,

       Year(Date_Tmp) as Year,

       Capitalize(Month(Date_Tmp)) as Month,

       Day(Date_Tmp) as Day,

       WeekDay(Date_Tmp) as DayWeek

RESIDENT TmpCalendar;

INNER JOIN

Month_Tmp: //to ensure a correct "sort by load order"

LOAD * INLINE [

   Month, Month_Name

    1,Jan

    2,Feb

    3,Mar

    4,Apr

    5,May

    6,Jun

    7,Jul

    8,Aug

    9,Sep

    10,Oct

    11,Nov

    12,Dec

];

DROP Table TmpCalendar;

0 Likes
Creator II
Creator II

Nice example.

But one question: is it possible to do this in qlikSense?

Can you give me an example, please?

Thanks,

Sílvia

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-01-03 10:56 AM
Updated by: