Bar cart and Table mapping with two different input
I have a Qlik Sense application with one input file containing two sheets:
Month sheet – month-level detailed data
Period sheet – period summary data (H1, H2, Annual)
Current setup
I created a combined bar chart that displays:
Monthly bars using the Month sheet
Period summary bars (H1, H2, Annual) using the Period sheet
For the period bars, I am currently using only the latest month available.
I also have a table that is currently populated using the Month sheet.
Requirement
Although H1 / H2 / Annual bars are shown using the Period sheet, the table must always display data from the Month sheet, based on the selected period bar.
The expected behavior is:
When the user clicks H1 in the bar chart → The table should display Month data from April to September
When the user clicks H2 → The table should display Month data from September to March
When the user clicks Annual → The table should display Month data from April to March of the selected Fiscal Year
Problem
Since the bar chart period data comes from the Period sheet and the table data comes from the Month sheet, there is no direct association between them.
Question
What is the recommended approach in Qlik Sense to achieve this behavior?
You can either create H1 and H2 logic in the month table and keep the name of the fields same , so that after loading the data through associate joins both the columns can linked between two table. for further more details it would be helpful if you can share the column details.
