topic Re: Dealing with product name changes in QlikView https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661064#M1062220 <HTML><HEAD></HEAD><BODY><P>you can find there</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions</A></P><P><A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P></BODY></HTML> Mon, 22 Sep 2014 16:45:21 GMT Anonymous 2014-09-22T16:45:21Z Dealing with product name changes https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661061#M1062217 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>We have recently rebranded our product range, and many items now have different product names, and example - Extra Cold Winter Cycle has been replaced with Extra Cold Weather Cycle. My question is, is there a solution to being able to compare the figures after the name changes to the previous year's sales, or does it have to be considered a new product? Currently the users are having to manually compare the figures, which is not ideal!</P><P></P><P>Many thanks</P><P>Andrew</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661061#M1062217 2020-11-20T18:02:30Z Re: Dealing with product name changes https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661062#M1062218 <HTML><HEAD></HEAD><BODY><P>You need to think about Slowly Changing Dimension (SCD Type 2) implementation. If you have an Item Number (Business Key) in your data model - it wouldn't be a problem.</P></BODY></HTML> Mon, 22 Sep 2014 13:19:38 GMT https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661062#M1062218 Anonymous 2014-09-22T13:19:38Z Re: Dealing with product name changes https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661063#M1062219 <HTML><HEAD></HEAD><BODY><P>They will be different primary keys I believe.</P><P></P><P>Where can I find more information on SCDs? I'm sorry, very much new to Qlikview and the forum!</P><P></P><P>Thanks</P></BODY></HTML> Mon, 22 Sep 2014 13:24:08 GMT https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661063#M1062219 2014-09-22T13:24:08Z Re: Dealing with product name changes https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661064#M1062220 <HTML><HEAD></HEAD><BODY><P>you can find there</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions</A></P><P><A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P></BODY></HTML> Mon, 22 Sep 2014 16:45:21 GMT https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661064#M1062220 Anonymous 2014-09-22T16:45:21Z Re: Dealing with product name changes https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661065#M1062221 <HTML><HEAD></HEAD><BODY><P>Thank you very much, I will take a look.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Tue, 23 Sep 2014 08:05:56 GMT https://community.qlik.com/t5/QlikView/Dealing-with-product-name-changes/m-p/661065#M1062221 2014-09-23T08:05:56Z