topic how to develop Reports for SCD2 type table in QlikView https://community.qlik.com/t5/QlikView/how-to-develop-Reports-for-SCD2-type-table/m-p/786645#M278280 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have period_name and year,month,week filters in my report. And I have table with historical data also. In that customers are changing from one grade to&nbsp; another grade in over a period , in this we have grade,grade_start_date,grade_end_date, current_grade_flag(y-&gt; active in this grade, n-&gt; not active moved to some other grade) fields.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; so my requirement is to capture only count of active customers by grade for selected filter. ex: if i select 'ytd' in period_name filter then show only active customers count by grade. if i select year that year active customers count. can anyone provide me the logic in expression to implement the above requirem.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thanks in advance.</P></BODY></HTML> Thu, 20 Nov 2014 11:42:36 GMT sateeshkumar 2014-11-20T11:42:36Z how to develop Reports for SCD2 type table https://community.qlik.com/t5/QlikView/how-to-develop-Reports-for-SCD2-type-table/m-p/786645#M278280 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have period_name and year,month,week filters in my report. And I have table with historical data also. In that customers are changing from one grade to&nbsp; another grade in over a period , in this we have grade,grade_start_date,grade_end_date, current_grade_flag(y-&gt; active in this grade, n-&gt; not active moved to some other grade) fields.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; so my requirement is to capture only count of active customers by grade for selected filter. ex: if i select 'ytd' in period_name filter then show only active customers count by grade. if i select year that year active customers count. can anyone provide me the logic in expression to implement the above requirem.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thanks in advance.</P></BODY></HTML> Thu, 20 Nov 2014 11:42:36 GMT https://community.qlik.com/t5/QlikView/how-to-develop-Reports-for-SCD2-type-table/m-p/786645#M278280 sateeshkumar 2014-11-20T11:42:36Z Re: how to develop Reports for SCD2 type table https://community.qlik.com/t5/QlikView/how-to-develop-Reports-for-SCD2-type-table/m-p/786646#M278281 <HTML><HEAD></HEAD><BODY><P>See this document: <A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P></BODY></HTML> Fri, 21 Nov 2014 13:06:55 GMT https://community.qlik.com/t5/QlikView/how-to-develop-Reports-for-SCD2-type-table/m-p/786646#M278281 Gysbert_Wassenaar 2014-11-21T13:06:55Z