topic Re: Dimension Colors in QlikView

Dimension Colors

simsondevadoss — Sat, 25 Oct 2014 14:50:42 GMT

Hi ,

How to get different colors for dimensions in charts even if dimension values exceeds 18 ?

I should not get the same color again in my chart .

Thanks,

Simson

Re: Dimension Colors

ecolomer — Sat, 25 Oct 2014 14:54:19 GMT

You can personalize the colour using RGB(X, Y, Z) in the expression

Re: Dimension Colors

simsondevadoss — Sat, 25 Oct 2014 14:59:53 GMT

Thanks for your reply.

I cant hard-code it in my background expression. Since my dimension changes.

Do we have any other method to achieve this ?

Re: Dimension Colors

SunilChauhan — Sat, 25 Oct 2014 15:06:13 GMT

chart properties-> Color-> check multicolored

hope this helps

Re: Dimension Colors

simsondevadoss — Sat, 25 Oct 2014 15:07:53 GMT

What if dimension value exceeds 18 ?

I should not get same color in my chart.

Re: Dimension Colors

ecolomer — Sat, 25 Oct 2014 15:09:44 GMT

Your dimensions can change. This is not a problem.

Can you upload an example?

Re: Re: Dimension Colors

simsondevadoss — Sat, 25 Oct 2014 15:15:10 GMT

Please find the attached sample and data

Re: Dimension Colors

sorrakis01 — Sat, 25 Oct 2014 15:17:06 GMT

Hi,

Dimension value? or expresion value of the dimension?

If you need for your dimension then use calculated dimension.

Also, if you need for your expresions use the example of Enrique.

Regards,

Re: Dimension Colors

ashfaq_haseeb — Sun, 26 Oct 2014 07:19:18 GMT

Hi,

I don't think there exist a direct way to do that.

But checl if this helps.

http://community.qlik.com/docs/DOC-6972

http://community.qlik.com/docs/DOC-5189

http://community.qlik.com/docs/DOC-4505

if you really need it.

Then vote here.

http://community.qlik.com/ideas/2360

Regards

ASHFAQ

Re: Dimension Colors

ecolomer — Sun, 26 Oct 2014 07:54:01 GMT

Also you can assign for each value a value RGB(x,y,z)

See this example

Re: Re: Dimension Colors

kuba_michalik — Sun, 26 Oct 2014 09:02:27 GMT

You don't have to assign the colors to particular dimension values.

For example, this background color expression:

Pick(RowNo(),
    RGB(r,g,b),
    ... (more color expressions)
)

will work no matter what the chart dimension is. To avoid typing all those colors in expression, you could also store them in data and use something like

FieldValue('yourcolorfield',RowNo())