Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

Dimension without fact

Hi What is dimension without fact and fact without dimension data model ? can anyone explain me with the help of suitable raw data example  ?

Please do not attach any thread as I already went through all the available thread I want it with suitable raw data example ?

2 Replies
pradosh_thakur
Master II
Master II

hi

i know you have asked not to attach any thread still

https://community.qlik.com/thread/284540

check out this thread. Let me know if you need more i will prepare some data.

regards

Pradosh

Learning never stops.
Or
MVP
MVP

There's really not much to explain. You are not required to have a "fact" or "dimension" table in QlikView, though it is often helpful to consolidate your data into a fact/dimension structure for readability or other reasons such as master calendar connections. If you prefer, and have no specific requirements to the contrary, you can maintain the source data's structure in your QlikView files - for example, you can load data in a typical relational / normalized scheme that you'll likely find in most software databases.