Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Networkdays

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Networkdays

Not sure what's causing  your problem.

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

Regards,

Stefan

2 Replies
MVP
MVP

Re: Networkdays

Not sure what's causing  your problem.

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

Regards,

Stefan

Not applicable

Re: Networkdays

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 !!

Community Browser