Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimensions and Facts in QV

Hi,

I am new to BI & QV.

I want to know about Dimensions and Facts in QV..

Please share your thoughts on this please

Thanks in Advance....

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Dimensions and Measures

Read the blog posted by Henric will be helpful to you understand

regards

Mahesh

View solution in original post

3 Replies
Not applicable
Author

Hi,

Dimensions and Measures

Read the blog posted by Henric will be helpful to you understand

regards

Mahesh

MK_QSL
MVP
MVP

Consider you are working in a sales environment...

Dimensions are (Slowly Changing)

Customer, CustomerName, CustomerID, Supplier, SupplierID, SupplierName, Customer/Supplier Address,

EmployeeName, EmployeeID etc...

Facts Data/Tables are (Updating daily/regularly)

Invoice Qty, Invoice Price, Invoice Date etc...

Hope this help

Not applicable
Author

Dimension -

A dimension table typically has two types of columns, primary keys to fact tables and textual\descreptive data.

Fact -
A fact table typically has two types of columns, foreign keys to dimension tables and measures those that contain numeric facts. A fact table can contain fact’s data on detail or aggregated level.

regards

Mahesh T