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: 
smilingjohn
Specialist
Specialist

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 III
Specialist III

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 III
Specialist III

We use the Canonical Date model by Henric. 

smilingjohn
Specialist
Specialist
Author

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

jwjackso
Specialist III
Specialist III

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)