Tracking Historical Changes Through Naming Conventions and Their Totals

[Kayde_72]

I am working on a project with commodities and invoices that are tied to them. We review and change commodity names every once in a while and we lose the data behind the past data. Simply put, how do I track historical data of past commodity names and tie them to the new one?

Rough Example:

Commodity: Pie                Invoice Total: $2,500   January 1-Jan 31

Change----- made on Feb 1

Commodity: Pie ---> Pie Crust               Invoice Total: $3,000  Feb 1- Feb28

Change----- made on March 1

Commodity: Pie Crust ---> Pie Crust & Slices           Invoice Total: $1,000  March 1- March 31

I want to look up Pie Crust & Slices as the current commodity and have the historical invoices come with it. So

Search ---> Pie Crust & Slices  Invoice Total: $6,500   (Not the current $1,000)

I have a lot of commodities that have been through several changes like this, whether the change is through the account code or commodity name. I am not sure how to connect them. Any help is appreciated! Thank you

[Pillow410]

---

@skylightpaycard wrote:

I am working on a project with commodities and invoices that are tied to them. We review and change commodity names every once in a while and we lose the data behind the past data. Simply put, how do I track historical data of past commodity names and tie them to the new one?

Rough Example:

Commodity: Pie                Invoice Total: $2,500   January 1-Jan 31

Change----- made on Feb 1

Commodity: Pie ---> Pie Crust               Invoice Total: $3,000  Feb 1- Feb28

Change----- made on March 1

Commodity: Pie Crust ---> Pie Crust & Slices           Invoice Total: $1,000  March 1- March 31

I want to look up Pie Crust & Slices as the current commodity and have the historical invoices come with it. So

Search ---> Pie Crust & Slices  Invoice Total: $6,500   (Not the current $1,000)

I have a lot of commodities that have been through several changes like this, whether the change is through the account code or commodity name. I am not sure how to connect them. Any help is appreciated! Thank you

---

This is my general format, however it really depends on the specifics of how your websites are set up, and what you want to measure. For example, for many of my clients we set up 10+ events for GA for behavior analysis, but will lump 3-4 of them together for FB conversion tags if they represent the same business action, since FB limits you to 8 custom conversions now and the only thing we use FB for is tracking conversions, not analyzing the specific actions.

[MarcoWedel]

maybe helpful:

https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1...

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187