Insight Advisor – Comparative Line Chart for 2024 vs 2025 Sales by Month

Janakiramn — Wed, 25 Jun 2025 11:02:08 GMT

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.

Re: Insight Advisor – Comparative Line Chart for 2024 vs 2025 Sales by Month

diegozecchini — Thu, 10 Jul 2025 08:44:52 GMT

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:

Try a normalized structure like this:

Month|Year|Sales
Jan|2024|10000
Jan|2025|11000
Feb|2024|12000
Feb|2025|12500

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:

“Sales trend by Month, comparing 2024 and 2025”

let me know if helps

topic Re: Insight Advisor – Comparative Line Chart for 2024 vs 2025 Sales by Month in Insight Advisor

Insight Advisor – Comparative Line Chart for 2024 vs 2025 Sales by Month

Re: Insight Advisor – Comparative Line Chart for 2024 vs 2025 Sales by Month