topic multiple dates in model in QlikView

multiple dates in model

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

Hi Experts,

I have 3 tables in in model and all 3 tables are linked together by a single key. Table1 has subset ratio of only 1%, Table2 has 36% and Table3 has 99.92%.
Please note that dimensions are measures are in the same table.

Each table has its own Date field indicating when the transaction happened.

I wanted to create a striaght table in the UI with various multiple expressions(generally sum() & coun()) and Dimension is Date. Because the dates are different in each table, I am not sure how to acheive this??

Thanks!

Re: multiple dates in model

sunny_talwar — Wed, 14 Dec 2016 10:57:39 GMT

May be this thread might be useful

Canonical Date

Re: multiple dates in model

surajap123 — Wed, 14 Dec 2016 11:37:46 GMT

Hi Sunny,

Thanks for the link.

I will start working on it.
I assume multiple dates in a model very common. Do we always create canonical date for this situation or is there is eazy approach?

Also, if you know, could you give me a link table approach to solve the multiple dates issue.

Re: multiple dates in model

sunny_talwar — Wed, 14 Dec 2016 11:55:42 GMT

Well I am not sure if there are other ways or not, but AFAIK this is the best possible way to handle multiple days. It might look messy at first, but once you are done with your data model, you would love it on the front end.