topic Re: One Date Dimension in QlikView

One Date Dimension

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Thanks

Re: One Date Dimension

jwjackso — Thu, 09 Jul 2020 13:42:45 GMT

We use the Canonical Date model by Henric.

Re: One Date Dimension

smilingjohn — Thu, 09 Jul 2020 13:54:26 GMT

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

Re: One Date Dimension

jwjackso — Thu, 09 Jul 2020 14:22:23 GMT

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)