Link Date Calendar to Link Table

[#1]

I am still relatively new to QlikView, however I require a Day, Month, Quarter & Year Filter (List Box) to link to my Link table, based on the dates I select the object will dynamically analyses my Data model. However when I do link it to Inline table I receive an error stating Ambiguous results. My table looks like image attached, I have removed the Day, Month, Year Inline Tables, if someone could please help me.

[#2]

He Gerhard,

You usually get the ambiguous results if there is some 'loop/circular reference'  in your data model. For example table 1 is connected to table 2 and table 3, table 2 is connected to table 3.

You should remove these circular references.

hope this helps.

gr.

Frank

[fernando_tonial]

Hi Gerhard,

You can try this.

Create 2 variables.

LET vMonthStart = Date('01/01/2006');

LET vMonthFinish = Date(MonthEnd(Today()));

Create a table using the variables and AUTOGENERATE comand.

CALENDAR:

LOAD

[Date] as Date,

Day(Date) as Day,

Month(Date) as Month,

Year(Date) as Year,

MonthName(Date) as [MonthYear],

ceil(Month(Date)/3)&'º Q' as [Quarter];

LOAD

Date(MonthEnd(Today())- Recno()+1,'DD/MM/YYYY') as [Date]

AUTOGENERATE(vMonthFinish-vMonthStart+1);

Best Regards,

Tonial.

[#4]

@fernando.tonial, finally got the date to link with teh LINK table, however if I make any selection (lets say 2012) all my object loose all there data, no in my mind if I select 2012 from calander, it should link to LINK table that is also linked to Orders, so all the orders with CreatedDate (**/**/2012) should be previewed.

Any advice on this?

[er_mohit]

see the attached file

[fernando_tonial]

You must verify the format of the fields that make the association between the tables. In this case the field is the Date.

[#7]

Found out that my Link table only pull the first table data, not the rest:

//Company Date

Link:

LOAD

compID

,Comp_CreatedDate as Date

,'Comp_Created' as DateType

RESIDENT Company

;

// Cases Date

CONCATENATE (Link)

LOAD

caseID

,Case_CreatedDate as Date

,'Case_Created' as DateType

RESIDENT Cases

;

// Person Date

CONCATENATE (Link)

LOAD

personID

,Pers_CreatedDate as Date

,'Pers_Created' as DateType

RESIDENT Person

;

//  Opportunity

CONCATENATE (Link)

LOAD

oppID

,Oppo_CreatedDate as Date

,'Oppo_Created' as DateType

RESIDENT Opportunity

;

// Lead

CONCATENATE (Link)

LOAD

leadID

,Lead_CreatedDate as Date

,'Lead_Created' as DateType

RESIDENT Lead

;

[er_mohit]

write this code in every load on first

Date(Date#(Date,'DD-MM-YYYY'))as ABC,

i think it might be help you..

all procedure same only add this code in every load at starting time like

//Company Date

Link:

LOAD

Date(Date#(Date,'DD-MM-YYYY'))as ABC,

compID

,Comp_CreatedDate as Date

,'Comp_Created' as DateType

RESIDENT Company

if this can't helps you then

replace concatenate and use inner join

[#9]

With no luck er.mohit

The LINK table only pulls the first (Company) table and has the other fields as columns with no values, I have tried the Date as well the Inner Join with no luck.

Any other suggestions?

[er_mohit]

send me your overall script.

i ll try my best.