Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sateeshkumar
Creator
Creator

how to develop Reports for SCD2 type table

hi,

     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  another grade in over a period , in this we have grade,grade_start_date,grade_end_date, current_grade_flag(y-> active in this grade, n-> not active moved to some other grade) fields.

     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.

          Thanks in advance.

1 Reply
Gysbert_Wassenaar

See this document: IntervalMatch and Slowly Changing Dimensions


talk is cheap, supply exceeds demand