Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
olivier_vincon
Partner - Contributor II
Partner - Contributor II

Problem with right keep

Hi,

I would like join ORDRE and a master calendar table called 'Master_Cal' on field 'OTSDTDEP' and I would to see these 2 tables separately. I need to see all the date values of the master calendar. So I did a right keep of ORDRE on Master_Cal like below but it doesn' work. It seems that only intersection has been taken.

Why ? Is there a solution for it ?

Right Keep(ORDRE)

Master_Cal:
LOAD
Floor(Date) as Opendate,
Date as OTSDTDEP,
Year(Date) as YearCal,
'S'& num(ceil(month(Date)/6)) as SemestreCal,
'T'& num(ceil(month(Date)/3)) as TrimestreCal,
MonthName(Date) as MoisCal,
year(Date) & '-' & Num(Month(Date),'00') as PERIODE_YM_Cal,
Day(Date) as DayCal//,
//Week(Date) as Week
Resident Calendar;

 

Best regards,

Michel

1 Solution

Accepted Solutions
marcus_sommer

How did you check the data? I think they will be there - if you creates a tablebox and adds all fields from the Master_Cal you should see all records.

- Marcus

View solution in original post

3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Could you post the content of the ORDRE table?

Maybe its joining more than 1 field.

olivier_vincon
Partner - Contributor II
Partner - Contributor II
Author

No, I have seen the model, there is only the field 'OTSDTDEP' between these 2 tables.

But table ORDRE is linked to other tables.
marcus_sommer

How did you check the data? I think they will be there - if you creates a tablebox and adds all fields from the Master_Cal you should see all records.

- Marcus