Solved: Dealing with product name changes - Qlik Community

Report Inappropriate Content · ‎2014-09-22

Hi Guys,

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!

Many thanks

Andrew

Anonymous · ‎2014-09-22

you can find there

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions

IntervalMatch and Slowly Changing Dimensions

View solution in original post

Anonymous · ‎2014-09-22

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.

Report Inappropriate Content · ‎2014-09-22

They will be different primary keys I believe.

Where can I find more information on SCDs? I'm sorry, very much new to Qlikview and the forum!

Thanks

Anonymous · ‎2014-09-22

you can find there

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions

IntervalMatch and Slowly Changing Dimensions

Report Inappropriate Content · ‎2014-09-23

Thank you very much, I will take a look.