topic Re: Fact Table in QlikView

Fact Table

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

Dear Qlikview community,

I am new to Qlikview and I would like to know if you have a document that explains how to build a Qlikview FACT table?

Kind regards,

Abdallah

Re: Fact Table

YoussefBelloum — Fri, 04 May 2018 10:40:55 GMT

Hi,

there is no such document but I can recommend you to understand the BI Data models first, here is two examples:

Star schema - Wikipedia

Snowflake schema - Wikipedia

as soon as you understand your data and know what is the Model you want to build, there is different techniques, like:

- concatenating table

- Link table technique

Re: Fact Table

Peter_Cammaert — Fri, 04 May 2018 10:44:51 GMT

You posted the same question in the same forum two more times. This isn't necessary and may divert attention and fragment your feedback.

Fact Table

You can delete the other two questions without any problem by using the Delete entry from the Actions menu (top left).

Thanks

Re: Fact Table

Lisa_P — Fri, 04 May 2018 10:47:42 GMT

Hi Youssef,

Typically Fact tables have dates or transactional data that has many entries or values. Dimensional data tables usually contain the fields to categorize or group the facts so that you can see the breakdown of your measures by something descriptive or time groups like years. months etc.

Regards,

Lisa

Re: Fact Table

ramasaisaksoft — Fri, 04 May 2018 11:11:14 GMT

Hi Abdallah,

Hearty welcome to QlikView Community.

Points you need to remember while you are learning QV

Pre- Requisite Knowledge required while learning any BI(Business Intelligence Tools)

Data base Knowledge(Tables,Rows,Columns,Database,Database server) up to Joins Types
Data warehouse Concepts (Dimension,Fact Table,Star & Snow Flake Schema)...etc.
then start learn QlikView so that you will get smoothly expert into any BI Tool.

Fact Table:

A fact table is a primary table in a dimensional model.

A Fact Table contains

Measurements/facts
Foreign key to dimension table

for better understanding please go through the below link

https://www.guru99.com/fact-table-vs-dimension-table.html

Re: Fact Table

YoussefBelloum — Fri, 04 May 2018 11:58:54 GMT

Hi Lisa,

I think that you wanted to answer Abdallah ?