Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod1992
New Contributor

Calculation of Networkingdays

Hi,

I have Oct2018,Nov2018,Dec2018 and Jan2019 data and I want to calculate the Networkingdays for Jan2019.

How can I do it?

Please help me out with your suggestion @sunny_talwar 

Thanks & Regards,

Vinod

3 Replies

Re: Calculation of Networkingdays

Would you be able to share some sample data and the output you expect to see from it?

Partner
Partner

Re: Calculation of Networkingdays

Maybe this is what you're looking for?

 

Load

YearMonth,

Networkdays(monthstart(YearMonth), monthend(YearMonth)) as NoOfWorkdays

;

Load

 Date#(YearMonth, 'MMMYYYY') AS YearMonth

inline [

YearMonth

Oct2018,

Nov2018,

Dec2018 

Jan2019 ];

Please ekskuse my Norglish and Swenglish typos.
Highlighted
VishalWaghole
Valued Contributor II

Re: Calculation of Networkingdays

If you want to display in Text object then follow below expression.
By default you will get maximum network days count and on selection of YearMonth you will get respective month network days.

=NetWorkDays(MonthStart(Max(YearMonth)),MonthEnd(Max(YearMonth)))

Thanks,
Vishal