topic Re: Dimension without fact in QlikView https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429535#M800426 <HTML><HEAD></HEAD><BODY><P>Can you share your table and other details means data model details.</P></BODY></HTML> Tue, 05 Dec 2017 13:45:51 GMT its_anandrjs 2017-12-05T13:45:51Z Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429530#M800421 <HTML><HEAD></HEAD><BODY><P>Hi can anyone explain me how to deal with data model contains only dimension tables that is dimension without fact ? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429530#M800421 dhavalvyas 2020-11-25T16:16:04Z Re: Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429531#M800422 <HTML><HEAD></HEAD><BODY><P>Can you post the sample data?</P></BODY></HTML> Tue, 05 Dec 2017 13:13:51 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429531#M800422 Anonymous 2017-12-05T13:13:51Z Re: Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429532#M800423 <HTML><HEAD></HEAD><BODY><P>That is the definition of "Fact less Fact table" and FYQ, What you want?</P></BODY></HTML> Tue, 05 Dec 2017 13:19:41 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429532#M800423 Anil_Babu_Samineni 2017-12-05T13:19:41Z Re: Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429533#M800424 <HTML><HEAD></HEAD><BODY><P>I don't have data right now but in actual scenario how the deal with such situations ? What is the best practice to deal with such situations&nbsp; ? </P></BODY></HTML> Tue, 05 Dec 2017 13:33:18 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429533#M800424 dhavalvyas 2017-12-05T13:33:18Z Re: Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429534#M800425 <HTML><HEAD></HEAD><BODY><P>Read this <A href="http://dwhlaureate.blogspot.in/2012/08/factless-fact-table.html" title="http://dwhlaureate.blogspot.in/2012/08/factless-fact-table.html">What is a FACTLESS FACT TABLE?Where we use Factless Fact</A> and same you can implement in Qlikview but it is not respect to maintain loading the fact less fact table until unless master table </P></BODY></HTML> Tue, 05 Dec 2017 13:36:30 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429534#M800425 Anil_Babu_Samineni 2017-12-05T13:36:30Z Re: Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429535#M800426 <HTML><HEAD></HEAD><BODY><P>Can you share your table and other details means data model details.</P></BODY></HTML> Tue, 05 Dec 2017 13:45:51 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429535#M800426 its_anandrjs 2017-12-05T13:45:51Z Re: Dimension without fact https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429536#M800427 <HTML><HEAD></HEAD><BODY><P><EM>without FACT what are you trying to report then ?? just a plan data you need to show in the QV report </EM></P></BODY></HTML> Tue, 05 Dec 2017 13:48:44 GMT https://community.qlik.com/t5/QlikView/Dimension-without-fact/m-p/1429536#M800427 avinashelite 2017-12-05T13:48:44Z