Discussion Board for collaboration related to QlikView App Development.
Please find the attchment of the QVW file .
I have three date fileds(IssueDate , DeliveredDate and CLosed Date ) in my fact table and i need to have one common dimension field f week from "IssuedDate" . how can i achive this ?
If your 3 dates are on 1 fact table, you will create a bridge table between the fact table and the master calendar.
Fact(key) -> Bridge (key,canonical date, date type)->master calendar (canonical date,date type)
Number of close on a date, chart dimension of canonical date and expression would be
View solution in original post
We use the Canonical Date model by Henric.
I amram confused with this as I have only one table with multiple dates .