topic Re:Load colour in QlikView

Re:Load colour

Chanty4u — Thu, 18 Feb 2016 08:29:54 GMT

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

tresB — Thu, 18 Feb 2016 08:40:36 GMT

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

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

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

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

...

PFA

tresB — Thu, 18 Feb 2016 08:42:20 GMT

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

Edit: sample attached

Chanty4u — Thu, 18 Feb 2016 08:59:04 GMT

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.?

tresB — Thu, 18 Feb 2016 09:09:29 GMT

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

Chanty4u — Thu, 18 Feb 2016 09:23:19 GMT

Excellent.Perfect.

Thanks

Suresh