Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.