Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

picking out working days for a particular month

Hi experts,

i have the following script

FOR i = 0 to 12

LET vMonthT = MONTH(ADDMONTHS($(vToday),-$(i)));

LET vMonthN = NUM(MONTH(ADDMONTHS($(vToday),-$(i))));

LET vYearT= YEAR($(vToday));

//LET vYearT = YEAR(ADDMONTHS($(vToday),-$(i)));

  SRDaysMonth:

  LOAD

  BRNO,

  MONTHNAME(MAKEDATE($(vYearT),$(vMonthN),1)) as SALESMONTH,

  SUM(SRDAYS) as SRDAYS

  FROM

  [\BRANCH_CALENDAR.qvd]   (qvd)

  WHERE EXISTS(BRNO) AND YEAR(BHDATE) = '$(vYearT)' AND MONTH(BHDATE) = '$(vMonthT)' AND

BHDATE < $(vToday)

  GROUP BY BRNO;

Next i;

LET vMonthT =;

LET vYearT =;

LET vMonthN=;

from the above script how can i get SRDAYS for current month alone. (SRDAYS will vary according to the BRNO. it is nothing but the working days)

i have already set some variables to define current date,year,month......previous months,years.....

Please assist me in fixing this issue