topic Re: Keep the same color in QlikView

Keep the same color

Anonymous — Fri, 04 Apr 2014 16:10:09 GMT

Hi guys,

I have a pie chart with 3 tags.

I want to click on any of these tags, colors and position don't be changed.

It happened because I use condition with IF.

Could you suggestion how to use the same expression, but use set analysis?

Or other tricks to get it?

Thanks,

nizamsha — Fri, 04 Apr 2014 16:14:17 GMT

in color tab check persistent color or in expression tab background write the condition for color

Anonymous — Fri, 04 Apr 2014 16:44:13 GMT

I wrote the condition with IF, it didn't work.

I need also keep for each tag the same color.

jerem1234 — Fri, 04 Apr 2014 17:43:03 GMT

See if attached is what you want. Used this formula for background expression:

pick(match(only({<VariableName=>}VariableName), 'A', 'B', 'C'), RGB(210,247,130), RGB(247,235,126), RGB(247,165,151))

Hope this helps!

EDIT: You'll need to change your sort expression also to:

match(only({<VariableName=>}VariableName),'A','B','C')

Anonymous — Fri, 04 Apr 2014 17:49:56 GMT

Thanks. I used the same expression for sort too.