topic Dimension without fact in QlikView

Dimension without fact

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

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 ?

Re: Dimension without fact

pradosh_thakur — Sun, 24 Dec 2017 14:58:37 GMT

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

Re: Dimension without fact

Or — Sun, 24 Dec 2017 15:02:22 GMT

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.