topic Re: Custom Master Calendar for Each Country in QlikView

Custom Master Calendar for Each Country

Mon, 01 Jun 2015 05:13:18 GMT

I need to create a custom master calendar for each country based on their weekend. The weekend for each country should be labelled based on the weekend for that country.

My generic calendar -

MinMax:

LOAD

Min([week]) As MinDate,

Max([week]) As MaxDate

FROM dates.qvd (qvd);

LET vMinDate = Num(Peek('MinDate', 0, 'MinMax'));

LET vMaxDate = Num(Peek('MaxDate', 0, 'MinMax'));

DROP TABLE MinMax;

TempCal:

LOAD

date($(vMinDate) + rowno() - 1) As TempDate

AutoGenerate

$(vMaxDate) - $(vMinDate) + 1;

The country weekend information comes from another table in the below format -

Country_Weekend:

LOAD

country_id As [Country ID]

, weekend As [Country Weekend]

FROM country.qvd (qvd);

Weekend can take values like 5,6 or 7.

I will eventually be using this information for calculating the number of working days for each country based on the user selections of dates.

Re: Custom Master Calendar for Each Country

Mon, 01 Jun 2015 05:26:37 GMT

Is that possible to provide app with sample data?

Re: Custom Master Calendar for Each Country

marcus_sommer — Mon, 01 Jun 2015 06:39:33 GMT

I wouldn't generate different calendars else create three different workday-flags within the calendar. I create such workday-flag of 0 or 1 per nested if-loop over weekday and an applymap() to holidays to define if a day is a workday or not and use then simply a sum(workdayFlag) within the ui. In your case you would have three flags which you set manually within the expressions - but this could be also automated matched per pick(match()) expression.

- Marcus