Color of lines in line chart are changing with selection in month filter

[qlik4asif]

Hi team,

I have a line chart with month and Function(Having 4 different values) as Dimensions, One expression

So i have a line chart with four lines (Since having Four Functions(Dimension))

I have given colors according to Function in background color of the xpression, Initially the lines were displaying according to Functions colors which i have given in background color

Pick(WildMatch(Function,'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))

But when i select month, the colors of the line were changing, How to restrict it

thanks in advance

[qlik4asif]

I think i need to bypass the Month dimension in Pick expression

Pick(WildMatch(Function,'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))

I know to bypass in Set analysis, but how to do in pick expression

[sunny_talwar · Accepted solution]

May be this

Pick(WildMatch(Only({<Month>}Function),'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))

[qlik4asif]

Hi Sunny,

Superb bro, it solved.

Can you explain how the expression works

Thanks

[sunny_talwar]

Function is the field where you needed to ignore selection. So, in order to use set analysis, I used Only() function around it...

[qlik4asif]

I need to ignore Month selection

Only({<Month>}Function) 

in the above expression we are ignoring month and considering function right,

please correct me if i am wrong

[sunny_talwar]

We are ignoring selection in Month field for the field function is how I would put it

[qlik4asif]

OK Thanks