topic Re: Master Calendar Help in QlikView

Master Calendar Help

Anonymous — Wed, 26 Nov 2014 06:31:56 GMT

Hi All,

Please find my below Master Calendar script. The issue is,when I am selecting some dates it is working fine. For some of date,though I am having a value in the table,still it is not showing the date. Am I missing any thing in the script?

-Jay

Service:

Load Key,

Service_Creation_Date

From Service.xl;

Application:

Load Key,

Key1,

Application_Creation_Date

From Application.xl

Point:

Load Key1,

Point_Creation_Date

From Point.xl;

Temp_Cal:

Load Service_Creation_Date

Resident Service;

Concatenate

Load Application_Creation_Date As Service_Creation_Date

Resident Application

Concatenate

Load Point_Creation_Date As Service_Creation_Date

Resident Point;

Min_max_Date:

Load Min(Service_Creation_Date) As Min_Date

Max(Service_Creation_Date) As Max_Date

Resident Temp_Cal;

Let V_min=Num(Peek('Min_Date','0,'MinmaxDate');

Let V_max=Num(Peek('Max_Date','0','MaxMaxDate');

Temp_Cal_Creation:

Load Date($(V_min)+Rowno()-1) As Cal_Date_Creation

AutoGenerate $(V_max)-$(V_Min)+1;

Master_Calendar:

Load Cal_Date_Creation As Service_Creation_Date

Resident Temp_Cal_Creation;

Drop Tables Temp_Cal_Creation,Min_max_Date,Temp_Cal

Re: Master Calendar Help

its_anandrjs — Wed, 26 Nov 2014 08:30:31 GMT

Hi,

Try this this is your complete script

Service:

Load Key,

Service_Creation_Date

From Service.xl;

Application:

Load Key,

Key1,

Application_Creation_Date

From Application.xls;

Point:

Load Key1,

Point_Creation_Date

From Point.xls;

Temp_Cal:

Load Service_Creation_Date

Resident Service;

Concatenate

Load Application_Creation_Date As Service_Creation_Date

Resident Application;

Concatenate

Load Point_Creation_Date As Service_Creation_Date

Resident Point;

Min_max_Date:

Load Min(Service_Creation_Date) As Min_Date,

Max(Service_Creation_Date) As Max_Date

Resident Temp_Cal;

LET V_min = Num(Peek('Min_Date',0,'Min_max_Date'));

Let V_max = Num(Peek('Max_Date',0,'Min_max_Date'));

Temp_Cal_Creation:

Load Date($(V_min) + Rowno() - 1) As Cal_Date_Creation

AutoGenerate $(V_max) - $(V_Min) + 1;

Master_Calendar:

Load Cal_Date_Creation As Service_Creation_Date

Resident Temp_Cal_Creation;

Drop Tables Temp_Cal_Creation,Min_max_Date,Temp_Cal;

Regards,

Anand

Re: Master Calendar Help

Anonymous — Wed, 26 Nov 2014 10:05:28 GMT

Hi Anand,

If I am not wrong, you have updated the variable declaration part. But still I am having the same issue.

For Ex: If I select11/26/2014 from Master calendar even if I have date present at Application table, but those dates are not get selected.

This is my issue. Kindly let me know if you have any ideas?

-Jay

Re: Master Calendar Help

its_anandrjs — Wed, 26 Nov 2014 10:28:52 GMT

Provide any sample file or what is min and max date in the model.

Regards

Anand

Re: Master Calendar Help

Anonymous — Wed, 26 Nov 2014 10:37:54 GMT

Due to data sensitivity Iwont be able to share the data. Like any other Date fields, it is just simple Date field.As I said earlier though I am having value in tables,it is not get selected when I am selecting the Dates in Master Calendar

-Jay

Re: Master Calendar Help

its_anandrjs — Wed, 26 Nov 2014 11:52:12 GMT

Hi,

Then individually load table one by one and check this dates come or not in the table and then check in the tables after concatenate in the tables for field Service_Creation_Date. And then load min and max fields.

You can provide any sample file with few records.

Regards

Anand