topic Re: SCD in QlikView https://community.qlik.com/t5/QlikView/SCD/m-p/669215#M243224 <HTML><HEAD></HEAD><BODY><P>It depends on your use case. I suggest to read Ralph Kimball's "The Data Warehouse Toolkit". It contains a lot of examples related to common use cases.</P></BODY></HTML> Fri, 13 Jun 2014 07:31:07 GMT rbecher 2014-06-13T07:31:07Z SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669209#M243218 <HTML><HEAD></HEAD><BODY><P>Which type of SCd generally we can use in qlikview.</P><P>Type2 or type3</P></BODY></HTML> Thu, 12 Jun 2014 13:45:41 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669209#M243218 deepakqlikview_123 2014-06-12T13:45:41Z Re: SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669210#M243219 <HTML><HEAD></HEAD><BODY><P>I would suggest SCD type 2 but you can code what you want..</P></BODY></HTML> Thu, 12 Jun 2014 13:46:52 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669210#M243219 rbecher 2014-06-12T13:46:52Z Re: SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669211#M243220 <HTML><HEAD></HEAD><BODY><P>Hi to handle SCD in UI without using interval match function</P><P>Can you please give me some example.</P></BODY></HTML> Fri, 13 Jun 2014 07:12:23 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669211#M243220 deepakqlikview_123 2014-06-13T07:12:23Z Re: SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669212#M243221 <HTML><HEAD></HEAD><BODY><P>You should handle SCD in the load script and create a classical star schema data model. Create surrogate keys for each historical dimension record to link the right facts.</P></BODY></HTML> Fri, 13 Jun 2014 07:15:19 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669212#M243221 rbecher 2014-06-13T07:15:19Z Re: SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669213#M243222 <HTML><HEAD></HEAD><BODY><P>Can you please share with me example.</P><P></P><P>thanks</P></BODY></HTML> Fri, 13 Jun 2014 07:16:56 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669213#M243222 deepakqlikview_123 2014-06-13T07:16:56Z Re: SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669214#M243223 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions">Slowly Changing Dimensions</A>. Examples can be found under <A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P><P></P><P>HIC</P></BODY></HTML> Fri, 13 Jun 2014 07:29:19 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669214#M243223 hic 2014-06-13T07:29:19Z Re: SCD https://community.qlik.com/t5/QlikView/SCD/m-p/669215#M243224 <HTML><HEAD></HEAD><BODY><P>It depends on your use case. I suggest to read Ralph Kimball's "The Data Warehouse Toolkit". It contains a lot of examples related to common use cases.</P></BODY></HTML> Fri, 13 Jun 2014 07:31:07 GMT https://community.qlik.com/t5/QlikView/SCD/m-p/669215#M243224 rbecher 2014-06-13T07:31:07Z