Temporal tables (system-versioned tables) in Qlik / Qlik Sense?

[randallmaglio]

Hi, All,

Looking to migrate an app from SQL Server to Qlik.  I have not been able to find any information on using temporal (system-versioned) tables in Qlik for a Type-2 dimension requirement.

Thanks for any suggestions/pointers,

RM

[Marcus_Spitzmiller · Accepted solution]

Hi please see these links.  The below PDF is for QlikView but should also be applicable for Qlik Sense.

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

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-documents/1853/2/IntervalMatch...

[Marcus_Spitzmiller]

@randallmaglio does this help?

[randallmaglio]

Hi, Marcus,

It's a workable solution for slowly changing dimensions.  The blog covered the key use cases.  It would be nice to eventually see some of this provided systematically too.

Best regards,

Randy