Count of non working days between two dates

[#1]

Hi,

Is it possible to get a count of the non working days between two dates using version 8.5 using a chart?

A non working day consists of a Sunday or a list of dates in a config file. I am able to load the config file into Qlikview ok.

I have the max of one date (based on a list of criteria) and the max of another (based on a separate list of criteria) and from these dates I need to the count of non working days.

This needs to be done at a chart level as the date range been selected is dynamic.

Thanks,

Kevin.

[amars]

Try using NetWorkDays Formula.

But as far I know it takes sat, sunday as holidays , in that case will need to write a function in database to calculate the working days.

Regards

Amar

[#3]

Hi,

are you want to count sundays and holidays between two given dates ?..

If so then you can use Week function to count non working days.