Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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