topic Re: Qlik Sense Data Modeling in Connectivity & Data Prep

Qlik Sense Data Modeling

StacyCui — Wed, 17 Aug 2022 05:23:05 GMT

Hi, I am a new in Qlik Sense. I meet an issue of data modeling in my work.

Business Background:

We have two order tables that are respective CY ORand PY OR. In business scope. We have district structure that Territory→Branch→Office. Each year, we adjusted the structure a little, like maybe office A belongs to Branch AA in last year, but this year, it maybe belongs to Branch BB. So, the district structure in CY and PY order table, it doesn't completely same.

When I design the modeling, Is it necessary to build a district structure table as a dimension table to connect with the fact tables. Besides, for PY district structure, we don't has a record. I have to distinct the structure in PY OR table to obtain. Kindly appreciate to your reply.

Re: Qlik Sense Data Modeling

hic — Wed, 24 Aug 2022 09:57:24 GMT

On the situation with the two order tables: I would concatenate these so I get one single fact table:

Orders:
Load ... From CY ... ;
Concatenate (Orders)
Load ... From PY ... ;

If there is a mismatch with fields, a missing field will be padded with NULLs.

On the problem with the changing district structure: This is a situation with a "Slowly Changing Dimension". See more on
https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187
https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1479928

But for this to work, you need to have some historical data, so you can recreate the district structure of previous years.