Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

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
Esteemed Contributor

Re: Two date fields

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

1 Reply
YoussefBelloum
Esteemed Contributor

Re: Two date fields

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

Community Browser