Inlist equivalent

[FrankC]

Happy Friday

I am trying to create a QVD as a slowly changing dimension, but I am struggling a little.  I am able to store the current value and the one before that.  However if there are more than 2 changes, the first value is no longer visible.

What I am trying to do now is to find the current record and store that as a resident.  Any suggestions?  I created a key for using the group and max functions, but I am unable to use that value in the where clause to put back the complete recordset.

Thanks in advance for your help

Frank

[Brett_Bleess]

Not sure if this will help or not:

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

Regards,
Brett