topic Re: Networkdays in QlikView

Networkdays

Mon, 22 Aug 2011 13:44:15 GMT

Hi all,

I would like to try out some stuff around capacity planning. But I was looking for a way to create a table thet I can use so I can see at once for the next 12 months and for each month how many working days there are.

Jan. 21

febr. 18

March 20

....

In this way I can use the numbers to calculate the capcity in hours on each production line.

I've us the networkdays functions..; but it seems it only works when one month is selected. When i select mutiple months.. it just adds up.

Can someone give me som insight please

thank you in advance

Re: Networkdays

swuehl — Mon, 22 Aug 2011 14:02:56 GMT

Not sure what's causing your problem.

I have attached a simple example of how it should work.

Regards,

Stefan

Re: Networkdays

Tue, 23 Aug 2011 08:39:06 GMT

Thank you so much.

i was looking too long at complicated formulas that I've found here and there for this.

Did not realise it was that simple. thank you so much for your help.

Much apreciated !!