Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Employee
Employee

Re: Where can I change the default Bar Chart colour by IDs?

You might try creating the RGB values of your colour palette as a standalone field in your data model and then use the FieldValue() function to call out the required value. Using the example above it might look like...

FieldValue('Colour Palette', FieldIndex('field',field))

Not applicable

Re: Where can I change the default Bar Chart colour by IDs?

Hi Adam,

Thanks for your reply.

I am trying that but facing some issues.

You mean if I use

FieldValue('Colour Palette',fieldindex( $(=chr(39) & GetCurrentField([Cyclic_Dims]) & chr(39) ), $(='[' & GetCurrentField([Cyclic_Dims]) & ']' ) ))

This should give me the colors as defined in color palette. but not working as expected.

can you help me on this.

Thanks

Khushboo

Highlighted
Employee
Employee

Re: Where can I change the default Bar Chart colour by IDs?

My guess would be that your dollar expansions are not working as expected. Break down each part of the expression into individual text boxes to see what response they are giving you. Might also be a good idea to test out the general idea on a much simplified app to make sure that the theory is sound.

Not applicable

Re: Where can I change the default Bar Chart colour by IDs?

Hi Adam,

Thanks for your reply.

I am trying that but facing some issues.

You mean if I use

FieldValue('Colour Palette',fieldindex( $(=chr(39) & GetCurrentField([Cyclic_Dims]) & chr(39) ), $(='[' & GetCurrentField([Cyclic_Dims]) & ']' ) ))

This should give me the colors as defined in color palette. but not working as expected.

can you help me on this.

Thanks

Khushboo

Employee
Employee

Re: Where can I change the default Bar Chart colour by IDs?

I've been playing around with this. Given a field of 'Person' and a Palette field of 'Palette' the following expression returns the correct RGB values

=FieldValue('Palette', FieldIndex('Person', Person))

However, this is then not being applied correctly as a background colour in the chart. Here I have assigned the expression as a background colour and as text on the data point.

Colour Challenge.png

Not sure where to go from here.

kuczynska
Contributor III

Re: Where can I change the default Bar Chart colour by IDs?

Did you try to use Multicolored option?sc1.PNG


I'm not sure if that will help as I have no idea how many dimension you are using etc.