Split of month-values into workingday-values

[sunny_talwar]

Script should be the same for QlikView or Qlik Sense

Table:

LOAD *,

If(Match(WeekDay(Date(MonthStart + IterNo() - 1)), 'Sat', 'Sun'), 0, [PlanSales (Month)]/WorkingDays) as [PlanSales (Day)],

Date(MonthStart + IterNo() - 1) as Date

While Date(MonthStart + IterNo() - 1) <= MonthEnd;

LOAD *,

MonthStart(Date#(MonthYear, 'MMM-YYYY')) as MonthStart,

Date(Floor(MonthEnd(Date#(MonthYear, 'MMM-YYYY')))) as MonthEnd,

NetWorkDays(MonthStart(Date#(MonthYear, 'MMM-YYYY')), Floor(MonthEnd(Date#(MonthYear, 'MMM-YYYY')))) as WorkingDays;

LOAD * INLINE [

    SaleRep, MonthYear, PlanSales (Month)

    04, Jan-2018, 50000

    04, Feb-2018, 60000

    04, Mar-2018, 70000

];

[reinholdgraf]

working.

Thanks a lot !

[shanu_s9]

Perfect Sunny,

I am new to qlikview, Could you please explain the script. It would be helpful.

Thank you .

[sunny_talwar]

Is there specific that you don't understand or are you looking for an explanation for the whole script?

[shanu_s9]

I am looking for explanation, Could you please explain.

Thank you.

[sunny_talwar]

Explanation for what my friend? Is there something specific you don't understand?