topic Conditional colors question in QlikView

Conditional colors question

Wed, 25 Jan 2012 16:02:41 GMT

Hoi there,

A lot of you will know the problem, when you reload, the colors of your chart might change.

A solution to this is writing a script for the colors.

O.a =If(V001='Immediately,' Green(), If(V001='After more than 3 tiries', Red(), If(....etcetera))

Now i have made this Pie graph. The big pie shows the selection, the small pie shows the total at all times (using the {1} in the count)

The colorscript works fine for the big one. However, I do not manage to write the color script for the small one in that way the for the small graph the colors stay the same (although using the {1} function in the expression)

What's the problem? Whenever I make a selection the small graph only shows the colors of the selection.

The idea is that the small graph does not change at ALL. I guess I'll have to use the {1} in my color script as well.

However, I don't know how to do that.

Any suggestions on this one?

Kind regards,

Tim Dries

Conditional colors question

Wed, 25 Jan 2012 16:10:04 GMT

See if this link helps

http://community.qlik.com/message/185566#185566

Re: Conditional colors question

Wed, 25 Jan 2012 16:10:15 GMT

See if this link helps

http://community.qlik.com/message/185566#185566

Conditional colors question

swuehl — Wed, 25 Jan 2012 16:29:27 GMT

Try using:

=If( only({1} V001) ='Immediately,' Green(), If(only({1} V001) ='After more than 3 tiries', Red(), If(....etcetera))

And I would suggest creating a color field in your data model, so you don't need the if() clauses in each chart.

Regards,

Stefan

Conditional colors question

Wed, 25 Jan 2012 22:22:02 GMT

Thanks man!

That was what I was looking for!

However, I'll take your advice with me will give the color field a change!

kind regards,

Tim