https://community.qlik.com/t5/QlikView/Inlist-equivalent/m-p/1702554#M451310 <P>Happy Friday</P><P>&nbsp;</P><P>I am trying to create a QVD as a slowly changing dimension, but I am struggling a little.&nbsp; I am able to store the current value and the one before that.&nbsp; However if there are more than 2 changes, the first value is no longer visible.</P><P>What I am trying to do now is to find the current record and store that as a resident.&nbsp; Any suggestions?&nbsp; 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.</P><P>Thanks in advance for your help</P><P>Frank</P> Sat, 16 Nov 2024 00:39:55 GMT FrankC 2024-11-16T00:39:55Z https://community.qlik.com/t5/QlikView/Inlist-equivalent/m-p/1702554#M451310 <P>Happy Friday</P><P>&nbsp;</P><P>I am trying to create a QVD as a slowly changing dimension, but I am struggling a little.&nbsp; I am able to store the current value and the one before that.&nbsp; However if there are more than 2 changes, the first value is no longer visible.</P><P>What I am trying to do now is to find the current record and store that as a resident.&nbsp; Any suggestions?&nbsp; 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.</P><P>Thanks in advance for your help</P><P>Frank</P> Sat, 16 Nov 2024 00:39:55 GMT https://community.qlik.com/t5/QlikView/Inlist-equivalent/m-p/1702554#M451310 FrankC 2024-11-16T00:39:55Z https://community.qlik.com/t5/QlikView/Inlist-equivalent/m-p/1709958#M451682 <P>Not sure if this will help or not:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187</A></P><P>Regards,<BR />Brett</P> Wed, 10 Jun 2020 21:50:12 GMT https://community.qlik.com/t5/QlikView/Inlist-equivalent/m-p/1709958#M451682 Brett_Bleess 2020-06-10T21:50:12Z