Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

One Date Dimension

Hi All,

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 ? 

smilingjohn_0-1594297281466.png

Thanks

 

1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

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

=Count({<DateType={'CloseDate'}>}key)

View solution in original post

3 Replies
jwjackso
Specialist II
Specialist II

We use the Canonical Date model by Henric. 

smilingjohn
Creator III
Creator III
Author

I amram confused  with this as I have only one table with multiple dates . 

jwjackso
Specialist II
Specialist II

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

=Count({<DateType={'CloseDate'}>}key)

View solution in original post