topic Re: System Calender in QlikView

System Calender

Mon, 29 Jun 2015 05:56:43 GMT

Client need system calendar instead of master calendar what does it mean

Re: System Calender

vardhancse — Mon, 29 Jun 2015 06:07:12 GMT

Hi,

Might be the normal calendar what they follow instead of company calendar

Re: System Calender

Mon, 29 Jun 2015 06:10:43 GMT

what is normal calender

Re: System Calender

vardhancse — Mon, 29 Jun 2015 06:29:57 GMT

In general will have 2 calendars.

1.Normal calendar

a. april to march

2. fiscal calendar

a.it depends on the country where the company is being operated.

like fiscal year may start from Jan to december

Re: System Calender

Mon, 29 Jun 2015 06:33:22 GMT

but as per my client this is not depend on any of the transaction table. it work as per system date

Re: System Calendersvenkita — Mon, 29 Jun 2015 06:37:07 GMT
The following script will give you a auto generated calendar based on min and max date, the max date is calculated as current date + 60
LET vDateMin   = Num(MakeDate(2012,1,1)); 
LET vDateMax   = Floor(MonthEnd(Today()+60)); 
LET vDateToday = Num(Today()); 
  
TempCalendar: 
LOAD  $(vDateMin) + RowNo() - 1       AS DateNumber, 
      Date($(vDateMin) + RowNo() - 1) AS TempDate
      AUTOGENERATE 1 
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);
        
Star_Calendar:
Load
     TempDate                                               As Star_Date,
     Week(TempDate)                                         As Star_Cal_Week,
     Day(TempDate)                                          As Star_Cal_Day,
     Month(TempDate)                                        As Star_Cal_Month,
     Num(Month(TempDate))                                   As Star_Cal_MonthNum,
     Year(Date(TempDate,'DD/MM/YYYY'))                      As Star_Cal_Year,
     Num(Num(Year(TempDate))& Num(Month(TempDate),'00'))    AS Star_Cal_YearMonth,
     Month(TempDate) &'-'&Year(Date(TempDate,'DD/MM/YYYY')) AS Star_Cal_YearMonthDesc,
     Weekday(TempDate)                                      As Star_Cal_WeekDay,
     'Q'&Ceil(Num(Month(TempDate))/3)                       As Star_Cal_Quarter,
     Ceil(Num(Month(TempDate))/3)                           As Star_Cal_QuarterNum
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
LET vDateMin   = ""; 
LET vDateMax   = ""; 
LET vDateToday = "";

Re: System Calender

vardhancse — Mon, 29 Jun 2015 06:54:03 GMT

Then not required any calendar, what ever dashboards/reports will be based on system date only.

Re: System Calender

Mon, 29 Jun 2015 07:50:08 GMT

Actually two different table sales order and purchase order table , but date entry is different in both the table, client want that calendar will be linked to both the table and capture all data not on basis of any of the date either sales or purchase table

Re: System Calender

Siva_Sankar — Mon, 29 Jun 2015 07:55:03 GMT

Shweta Singh,

You have to use Canonical date for this. Look here Canonical Date and find the attached example also for

Re: System Calender

Mon, 29 Jun 2015 11:57:26 GMT

I have data model with sales order ,purchase order and purchase receipt table, I have to show PO , purchase receipt in one table,

CRD is customer required date

I used your logic it won't work

Re: System Calender

Mon, 29 Jun 2015 13:06:13 GMT

as there no date field in purchase order table and all the three table are not linked with common filed

Re: System Calender

Tue, 30 Jun 2015 06:37:43 GMT

pfa of datamodel

Re: System Calender

Tue, 30 Jun 2015 06:39:03 GMT

pfa of datamodel