Documents for QlikView related information.
Last week I got a question to get number of working days between two dates
Have done some work and created enclosed QlikView File.
Suggestion and Correction would be highly appreciated !
I suggest to put holidays dates in an external file (e.g.Excel), because these especial days can vary fron country to country and from year to year (e.g. Argentina).
I was searching for ages for something like this online, fantastic post and so simple in comparison to other examples on other threads.
Hello Guys, I find this one is very helpful, But i have more tricky requirement than this one.
I have to take the sum(Sales) and multiply it by the current working day in the month say today is Aug 5th but working day number is 3. and then divide it by the no of working days in the month which is for Aug 2015 it is 21 days so my equations should be like (Sum(sales)*3)/21.
is there a way i could find out the current working day number and also the no of working days in the month.
You could use num(WeekDay(today())) to get the current day number in the week.
The document on this post will help you with the number of work days left.
Hope that helps,