Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try like below
= if (Year = max (Total Year) -1, yellow (), if (Year = max (Total Year) -2, green (), blue ()))
Thank you for your response. Unfortunately the formula doesn't work 😞
its working fine.
Sorry for the missunderstanding. The years are shown as a single line.
And I need a color for every single year.
Can you provide sample qvf file.
I have the "Qlik Sense Enterprise" version. I don't think I can do an export with that. Or do you know how?
Can't anyone help?