Fact Table

[absekrafi]

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

[YoussefBelloum]

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

[Peter_Cammaert]

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

Fact Table

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

Thanks

[Lisa_P]

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

[ramasaisaksoft]

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

1. Measurements/facts
2. Foreign key to dimension table

for better understanding please go through the below link

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

[YoussefBelloum]

Hi Lisa,

I think that you wanted to answer Abdallah ?