Discussion board where members can get started with Qlik Sense.
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,
Would you be able to share some sample data and the output you expect to see from it?
Maybe this is what you're looking for?
Networkdays(monthstart(YearMonth), monthend(YearMonth)) as NoOfWorkdays
Date#(YearMonth, 'MMMYYYY') AS YearMonth