Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

MVP
MVP

Re: Split of month-values into workingday-values

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

];

5 Replies
reinholdgraf
Contributor

Re: Split of month-values into workingday-values

working.

Thanks a lot !

shanu_s9
New Contributor II

Re: Split of month-values into workingday-values

Perfect Sunny,

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

Thank you .

MVP
MVP

Re: Split of month-values into workingday-values

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

shanu_s9
New Contributor II

Re: Split of month-values into workingday-values

I am looking for explanation, Could you please explain.

Thank you.

MVP
MVP

Re: Split of month-values into workingday-values

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