Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anuhegde
Contributor III
Contributor III

Colouring a line chart based on different dimensions

Hi all,

I have a line chart with 2 dimensions, year and country.

The measure is such that when I select a country, I can see sum(sales) in each year for that country. When I select a country and a compared country,The line chart shows the sum(Sales) for each year for 2 countries(country and compared country).

There should be only one country selected but I can select any number of compared countries. Basically it is comparing the sum(Sales) for a country with other countries.

The problem is when color property is set to auto, the chart shows grey color for both country and compared country. When the color property is set to color by dimension, it shows the colour for the country but grey for compared country.

I want to see the colour for country and also for compared country when compared country is selected. Different color should be displayed for different countries.

How can I do this?

Thanks in advance,

Anusha.

2 Replies
isingh30
Specialist
Specialist

Can you show some sample input & output of your requirement? If possible, please share data in excel format.

Thank you!

mikaelsc
Specialist
Specialist

i guess you'll be able to go much further into analysis possibilities if you look into alternate states:

Comparative Analysis - Alternate States with Qlik Sense