Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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.

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