topic Re: Expression in QlikView

Expression

Tue, 05 Nov 2013 16:19:29 GMT

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

Re: Expression

swuehl — Tue, 05 Nov 2013 16:24:08 GMT

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

Re: Expression

Tue, 05 Nov 2013 17:03:57 GMT

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

Cal_day

Cal_week

Cal_year

Re: Expression

swuehl — Tue, 05 Nov 2013 17:09:02 GMT

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

Re: Expression

Tue, 05 Nov 2013 17:20:33 GMT

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

Regards