topic Re: Generate Trading Days from Date range in QlikView

Generate Trading Days from Date range

Fri, 21 Mar 2014 16:16:19 GMT

Hi all,

Please see attached excel file. in Data tab I have data like...

Branch, BranchopeningDate

In "I Want" tab the data I want like displayed

Actually user should have option like in pic to choose date range

Once they select date then By month and Branch it should calculate Trading Days.

For Trading Day calculation below rule are apply

also need to consider UK Bank holidays.

Please help!!!

Vinay

Colin-Albert — Fri, 21 Mar 2014 16:26:50 GMT

The NetWorkDays() function almost does this, but does not allow you to count 1/2 days.

srchilukoori — Fri, 21 Mar 2014 17:20:12 GMT

Check the attached app.

Mon, 24 Mar 2014 09:11:13 GMT

Brilliant Srchilukoori,

It working perfect.

Many Many Thanks.

Regards

Vinay