Color line chart by fieldname "Year"

[reporting_neu]

Hello together,

I have a line chart with two dimensions. Month and Year. So I can compare the months in the years.

As an expression I used the following:
sum ({<year = {$ (= max (year)), $ (= max (year) -1), $ (= max (year) -2)}, quarter =, month =,% date =>} au.number)

Because Qlik Sense chooses colors that look too similar, I want to use a formula for my own colors.

I thought of the following formula:

= if (year = max (year) -1, yellow (), if (year = max (year) -2, green (), blue ()))

But it does not work.

Do you have a solution for me?

[MayilVahanan]

Hi @reporting_neu 

Try like below

= if (Year = max (Total Year) -1, yellow (), if (Year = max (Total Year) -2, green (), blue ()))

[reporting_neu]

Thank you for your response. Unfortunately the formula doesn't work 😞

[MayilVahanan]

Hi @reporting_neu 

its working fine. 

[reporting_neu]

Sorry for the missunderstanding. The years are shown as a single line.
And I need a color for every single year.

[MayilVahanan]

Hi @reporting_neu 

Can you provide sample qvf file. 

[reporting_neu]

I have the "Qlik Sense Enterprise" version. I don't think I can do an export with that. Or do you know how?

[reporting_neu]

Can't anyone help?