Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

gerhardl
Contributor II

Choose Persistent Colors

Hi there,

I'm sure this is a silly question - don't know why I can't figure this out or find another such discussion.

I have a Funnel Chart with 10 sections (based on the "CD Status" Dimension Split). It is sorted highest to lowest and I then chose colors per section, with the highest CD Status being the darkest.

When I make selections in other part of the QV doc and it for instance only shows CD Status 2 to 4, then the colors change to the top 3 "chosen" colors, which I want to always be for CD 7,8 and 9.

I know that I can choose Persistent colors, and then making selections will not change the colors - but when persistent colors is ticked, it ignores the order of the colors I chose, and assigns its own colors to each CD Status.

Any ideas?

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Choose Persistent Colors

lok at this printscreen...

statuscolor.PNG

5 Replies
Not applicable

Re: Choose Persistent Colors

did you try to define expression background color rhis way:

=if(CDstatus='CDstatus1', color(1),if(CDstatus='CDstatus2', color(2),if(CDstatus='CDstatus3', color(3),if(CDstatus='CDstatus4', color(4),color(5)))))

?

Not applicable

Re: Choose Persistent Colors

see att qvw

gerhardl
Contributor II

Re: Choose Persistent Colors

I have QV Personal Edition so unfortunately can't open your example.

As far as I can figure out, that will only affect the chart's background color?

I want to be able to choose the colors of the individual segments of teh chart, like you can do on the Colors TAB.

See image - I want to keep CD 0 and 1 white when I select only them. Currently they will change to Black and Dark Grey when I select them (colors 1 and 2). And if I use persistent colors then it mixes up the colors I have selected.

Thanks for helping

Not applicable

Re: Choose Persistent Colors

lok at this printscreen...

statuscolor.PNG

gerhardl
Contributor II

Re: Choose Persistent Colors

AAAAHHHHHHH!

Very nice, that works perfectly.

Thanks

Community Browser