Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Saravanan_Desingh

Handling Holidays & Vacations in Calendar

Hi,

I have a situation. I have list of employees. I am trying to create a dashboard making the Holidays and employee vacations as 0 hours.

The NetWorkDays help me to give the holiday list with DSE. But the vacations can not be given as it is applicable to the individuals and can not be given in DSE.

Can you please help me with ideas?

Something like Date={"*"}-{LeaveList} is not working.

Attaching the sample for your reference.

3 Replies
Anil_Babu_Samineni

Where you are trying this?

Something like Date={"*"}-{LeaveList} is not working.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

Hi Create one Variable like this

Let  vListofholidays= Concat(Chr(39)&LeaveList&Chr(39),',')  ;

Then  expression is like this

(NetWorkDays(Min(Date),Max(Date),$(VlistofHolidays)))

If  u dont want show the zero values , check supress zero values in presentation tab .

qlikviewwizard
Master II
Master II