Quarter Data Followed by Current Weeks in the Chart

[fetihcanakar]

Hello, in the chart, I will first display the data from my 'Complaint_DeclarationDate_Quarter' column, and then the current weeks will appear as 'Report_Week' progresses. I would appreciate your urgent support on this matter.

[robert_mika · Accepted solution]

Try like this:

1. X-Axis: Time Dimension
Use a combined field or dual axis if needed:

Complaint_DeclarationDate_Quarter for historical data

Report_Week for current/upcoming data

You can create a master calendar that aligns both fields to a unified timeline.

2. Y-Axis: Complaint Volume or KPI
Count of complaints or any relevant metric (e.g., severity index, resolution rate)

3. Set Analysis for Dynamic Filtering
qlik
Sum({
<Complaint_DeclarationDate_Quarter = {"*"},
Report_Week = {"<=$(=Week(Today()))"} // Only include weeks up to current
>} Complaint_Count)