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: 
wanyunyang
Creator III
Creator III

Two date fields

My source data has a date field named VisitDate. I created a master calendar with a field Date. In the dashboard, I created a Date filter, and a table with Visitdate as a dimension. If I want VisitDate show only the dates within the Date filter range, how should I write the function for VisitDate dimension?

Thanks in advance!

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

your master calendar should be linked to your fact table by the Date field (or key field which represent the date).

you can simply do this:

* Rename VisitDate to Date on your fact table


OR

*Rename Date to VisitDate on your MasterCalendar

View solution in original post

1 Reply
YoussefBelloum
Champion
Champion

Hi,

your master calendar should be linked to your fact table by the Date field (or key field which represent the date).

you can simply do this:

* Rename VisitDate to Date on your fact table


OR

*Rename Date to VisitDate on your MasterCalendar