Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dealing with product name changes

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

1 Solution
4 Replies
konstantin
Creator III
Creator III

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.

Not applicable
Author

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

Not applicable
Author

Thank you very much, I will take a look.