topic Problem in calenders in QlikView

Problem in calenders

Wed, 24 Feb 2010 04:51:57 GMT

hi,

I want to make a calender which can be accessed by any table without making a circular loop,

for ex: I have two Tables Invoice, Booking and i want the date to be accessed by calender, but the problem is both my tables have link with each other.

PLease Suggest me

Problem in calenders

deepakk — Wed, 24 Feb 2010 05:29:05 GMT

Hi Pranav,

TempCalendar:

Set

Soft_Date=Num('01/01/2006')

;

Set

Curr_Date=Today()

;

LOAD

$(Soft_Date)

+IterNo()-1 AS Num

Date

($(Soft_Date)+IterNo()-1) AS

Date

AUTOGENERATE

1 WHILE $(Soft_Date)+IterNo()-1 <= $(Curr_Date)

;

TempCalendar1:

Load

Date

Year

(Date) As Year

Month

(Date) As Month

Day

(Date) As

Day

Resident

TempCalendar;

Drop

Second Method:

If both the tables have the same primary key You can avoid the Circular Loop by Creating resident of first transaction table which will contain the primary key and the year,month,day field and concatenate with the second transaction table which will have the primary key of that table and Year,month and day.

And Link this new table with the Primary Keys. I hope this helps you out.

table TempCalendar ;

Deepak

Problem in calenders

deepakk — Wed, 24 Feb 2010 05:31:15 GMT

I have attach the code for Temp Calendar in the attachment

Problem in calenders

Wed, 24 Feb 2010 09:52:43 GMT

Thanks Deepak for your Reply,

Problem in calenders

Wed, 24 Feb 2010 09:55:35 GMT

I am having one more Question, if I have more Than 10 tables to access the Calender then....................

Please Suggest me..

Regards

Pranav

Problem in calenders

deepakk — Fri, 26 Feb 2010 08:45:37 GMT

Youu can link ten tables to the Calendar Table with Date Field but this will differe upon the situation.