Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

Re:Load colour

Hi all,

i have doubt on setting colour codes to the charts in a dashboard.

As  i hve loaded the  colors.xls  file into qvw .

My req is:

i have one barchart so the bar colours shud be display as per  order arragned in colours tab:

but  i need to set the default colours into my application  and  when ever i use the chart   that colours only applied to that bars?

how can i do this?

Thanks in advance.

Suresh

1 Solution

Accepted Solutions
MVP
MVP

Re:Load colour

Set your calculated colors as shown in happy.qvw and then update this color scheme in advanced settings (Document Default) like:

Untitled.png

5 Replies
MVP
MVP

Re:Load colour

You could use calculated color for individual bars. Expression would be like:

=$(=FieldValue('ColorCode',1))

=$(=FieldValue('ColorCode',2))

=$(=FieldValue('ColorCode',3))

...

PFA

MVP
MVP

Re:Load colour

Otherwise, you might associate the color code field with your dimension field and use that for background color.

Edit: sample attached

Highlighted
sureshqv
Esteemed Contributor III

Re:Load colour

thnx for response Tresesco.

As u said its fyn.   but  i add more bar values ok i can do it inline.

wen i want to apply to the same to other charts to be apply?

how can i? suppose i hve 10 colours   so that 10 colurs as default  and that shud be reflct to any chart i creates.?

MVP
MVP

Re:Load colour

Set your calculated colors as shown in happy.qvw and then update this color scheme in advanced settings (Document Default) like:

Untitled.png

sureshqv
Esteemed Contributor III

Re:Load colour

Excellent.Perfect.

Thanks

Suresh