Insight Advisor – Comparative Line Chart for 2024 vs 2025 Sales by Month
Hi Expertise,
I'm trying to use Qlik Insight Advisor to generate a comparative trend chart that shows 2024 and 2025 (User Selection) sales as two separate lines over the month axis.
I expect the output to have:
Dimension: Month
Measures: 2024 Sales and 2025 Sales (as separate lines)
However, Insight Advisor only shows a single combined line or uses MonthYear, not giving the comparative view I want.
What’s the best way to phrase my question or structure my data/model to make Insight Advisor return two lines – one for each year – on a shared month axis?
Any thoughts or workaround would be appreciated! Thanks in advance.
Hi, imho you’ll likely need to reshape your data and ask your question in a way that guides Qlik toward separating the lines by year. Here's how you can do it:
Avoid using separate columns for Sales_2024, Sales_2025, etc. These wide-format tables make it harder for Insight Advisor to generate comparative charts.
In the Insight Advisor interface, phrase your query like this:
"Show me sales by month and year with lines for each year"
Or use variations such as:
“Line chart of monthly sales, one line per year” “Compare sales over months for 2024 and 2025” “Sales trend comparison: 2024 vs 2025 by month”
If it insists on showing MonthYear, try filtering:
Hi, imho you’ll likely need to reshape your data and ask your question in a way that guides Qlik toward separating the lines by year. Here's how you can do it:
Avoid using separate columns for Sales_2024, Sales_2025, etc. These wide-format tables make it harder for Insight Advisor to generate comparative charts.
In the Insight Advisor interface, phrase your query like this:
"Show me sales by month and year with lines for each year"
Or use variations such as:
“Line chart of monthly sales, one line per year” “Compare sales over months for 2024 and 2025” “Sales trend comparison: 2024 vs 2025 by month”
If it insists on showing MonthYear, try filtering:
