Best practice for chart-table interaction when Period chart uses snapshot month, but table shows monthly detail
Hi Experts,
I am facing a chart-table interaction issue in Qlik Sense.
My period chart uses snapshot logic:
H1 = September snapshot
H2 = March snapshot
Annual = latest month snapshot
But when user clicks H1, the detail table shows April to September records.
The issue is:
If April–September table contains judgment ×, but September snapshot does not contain ×, then selecting × from the table makes the H1 chart blank or inconsistent.
Example:
June = ×
September = ○
H1 chart uses September, so H1 = ○.
But table shows Apr–Sep and contains × from June.
When user selects × from table, chart cannot show it because H1 snapshot does not have ×.
This seems to be a granularity conflict:
Chart = period snapshot month
Table = monthly detail range
What is the best practice in Qlik Sense?
Should I:
1. Keep snapshot-based chart and prevent/ignore monthly judgment selections from affecting it?
2. Change H1/H2/Annual to range-based calculation?
3. Separate monthly analysis and period analysis into different sheets?
I want to avoid confusing behavior for users and explain the correct design to the client.
