Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 

Handling Holidays & Vacations in Calendar


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

Where you are trying this?

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

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


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

Master II
Master II