Expression

[#1]

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

[swuehl]

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).

[#3]

thanks, which one is appropriate to use, these are the calendar choices i have,     

Cal_day

Cal_week

Cal_year

[swuehl]

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

[#5]

thanks for the help, looks like it working. am using Date.

Regards

T