topic Approach to SCD in QlikView in QlikView https://community.qlik.com/t5/QlikView/Approach-to-SCD-in-QlikView/m-p/1241012#M394078 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a business requirement where I need to track student information and completion of certain activities. But, these students have certain dimensions that change over time. For example, a student may be in City1 school branch and completed an activity on say 01/01/2014 and got transferred to City2 and completed the same activity on 01/01/2015. Now, the user has the option to input a certain date in the qlik dashboard and all the dimension related to the students must&nbsp; be as of the date entered in the dashboard. For example, if a user inputs 01/01/2014, all student information must be as of 01/01/2014 and any activity completion count should be aggregated by City1 and if the user selects 01/01/205, then all information of students must be as of the entered date and the aggregations should be by City2.</P><P></P><P>I tried looking up to Interval match, hash function, etc.. but any practical example would be helpful. If not practical example, any other approach to this issue will be appreciated.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 26 Jan 2017 15:30:58 GMT 2017-01-26T15:30:58Z Approach to SCD in QlikView https://community.qlik.com/t5/QlikView/Approach-to-SCD-in-QlikView/m-p/1241012#M394078 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a business requirement where I need to track student information and completion of certain activities. But, these students have certain dimensions that change over time. For example, a student may be in City1 school branch and completed an activity on say 01/01/2014 and got transferred to City2 and completed the same activity on 01/01/2015. Now, the user has the option to input a certain date in the qlik dashboard and all the dimension related to the students must&nbsp; be as of the date entered in the dashboard. For example, if a user inputs 01/01/2014, all student information must be as of 01/01/2014 and any activity completion count should be aggregated by City1 and if the user selects 01/01/205, then all information of students must be as of the entered date and the aggregations should be by City2.</P><P></P><P>I tried looking up to Interval match, hash function, etc.. but any practical example would be helpful. If not practical example, any other approach to this issue will be appreciated.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 26 Jan 2017 15:30:58 GMT https://community.qlik.com/t5/QlikView/Approach-to-SCD-in-QlikView/m-p/1241012#M394078 2017-01-26T15:30:58Z Re: Approach to SCD in QlikView https://community.qlik.com/t5/QlikView/Approach-to-SCD-in-QlikView/m-p/1241013#M394079 <HTML><HEAD></HEAD><BODY><P>Have a look at </P><P><A href="https://community.qlik.com/qlik-blogpost/3148">Slowly Changing Dimensions</A></P><P></P><P>and the referenced tech doc including sample files.</P></BODY></HTML> Thu, 26 Jan 2017 15:33:23 GMT https://community.qlik.com/t5/QlikView/Approach-to-SCD-in-QlikView/m-p/1241013#M394079 swuehl 2017-01-26T15:33:23Z