Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik4asif
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

7 Replies
qlik4asif
Creator III
Creator III
Author

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

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

OK Thanks