Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anuhegde
New 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
Contributor III

Re: Colouring a line chart based on different dimensions

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

Thank you!

mikaelsc
Contributor III

Re: Colouring a line chart based on different dimensions

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