Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am trying to build a logic based on selection of day, month or year,
based on 8 hours a day, so when i select 2013 only it should work out 8 hours day excluding the week ends. Then when i select 2013 and selection of months, need to work out 8 * months, and then same principle for weeks.
Can this be done? and how do i construct this?
What im showing is the time someone should be working for by selection.
Regards
Tyrone
Try maybe something like
=Networkdays( min(DateField), max(DateField) ) *8
assuming your selections limit the available dates in DateField (rename to an appropriate date field).
thanks, which one is appropriate to use, these are the calendar choices i have,
Cal_day
Cal_week
Cal_year
I would try with a date field, maybe Cal_day (I assume this is not just showing Monday to Sunday values).
There should be such a field when you are using a kind of master calendar.
http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar
thanks for the help, looks like it working. am using Date.
Regards
T