Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikikhalifer
Contributor II
Contributor II

Date field not connecting to master calendar

Hi , I have a master calendar in my model that is working fine for the whole model. I have added a new table that has date field in it. The problem is that this field is not connecting to the master calendar, more over it adds multiple empty records in my master calendar. Please help .. Thanks in advance

4 Replies
manoranjan_d
Specialist
Specialist

pls share the qvw file

Anil_Babu_Samineni

How is your Master Calendar script looks like?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bvssudhakar
Creator III
Creator III

I am also having same problem, Here i am attaching my qvw

My Requirement is Straight table with following fields.

1. Department

2. TitleName

3. jobid

4. No.of postions: (Expression is =Count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},DateType={'plcdate'}>}CandidateID) )

5. Enter Date

6. Placement Date.

7. Count of Days between Enter Date and placement Date

I am getting the problem (getting '-' only for date fields and count of days fields) to create the straight table with those fields.

Can you guys please check the qvw and help me out to achieve this

vikikhalifer
Contributor II
Contributor II
Author

Hi All ,

found a solution to my problem

It appeared that my date in my new table was a timestamp date and "remembered" the time in addition

to the actual date although displayed only the date.

Daystart(Date) solved the problem .

Thanks