topic Limiting Dimensions in QlikView https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957338#M328819 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have 4 dimensions in dimension table and I want to limit my fact table based on the&nbsp; matching combination of those Dimensions from Dimension table. How we can achieve it so that there wont be any facts without dimensions in the Fact table. Does exist clause suitable for this? As it suits in optimised load with only 1 Field I think. Please let me know. </P></BODY></HTML> Sat, 21 Nov 2015 15:38:43 GMT kishorj1982 2015-11-21T15:38:43Z Limiting Dimensions https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957338#M328819 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have 4 dimensions in dimension table and I want to limit my fact table based on the&nbsp; matching combination of those Dimensions from Dimension table. How we can achieve it so that there wont be any facts without dimensions in the Fact table. Does exist clause suitable for this? As it suits in optimised load with only 1 Field I think. Please let me know. </P></BODY></HTML> Sat, 21 Nov 2015 15:38:43 GMT https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957338#M328819 kishorj1982 2015-11-21T15:38:43Z Re: Limiting Dimensions https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957339#M328820 <HTML><HEAD></HEAD><BODY><P>I would use KEEP in this situation. It allows for matching on multiple columns.</P><P></P><P>-Rob</P></BODY></HTML> Sat, 21 Nov 2015 17:42:01 GMT https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957339#M328820 rwunderlich 2015-11-21T17:42:01Z Re: Limiting Dimensions https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957340#M328821 <HTML><HEAD></HEAD><BODY><P>Hi Rob Thanks for the response.</P><P>in my case if I am loading Dim Table first and then fact then I should use the Left Keep. Please confirm.</P></BODY></HTML> Sat, 21 Nov 2015 18:21:38 GMT https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957340#M328821 kishorj1982 2015-11-21T18:21:38Z Re: Limiting Dimensions https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957341#M328822 <HTML><HEAD></HEAD><BODY><P>Yes, I believe that would be a LEFT KEEP.</P></BODY></HTML> Sun, 22 Nov 2015 19:35:19 GMT https://community.qlik.com/t5/QlikView/Limiting-Dimensions/m-p/957341#M328822 rwunderlich 2015-11-22T19:35:19Z