Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Assign colors to certain columns

Hello community,

I have about 50 columns where each column contains either the term "act", "budg" or "YTD".

For example: Sales_act, Sales_budg, Sales_YTD

I would like to assign color codes to each of these three "categories", so that I can give every column containing the word "act" a blue color and "budg" a red one within the background color expression of chart objects. If it would work to actually put them in a category column I could try that as well.

I know how to set the color codes when I have records within one field but for individual columns I haven't figured out a solution yet.

What can I do to solve this?

Thank you,

Thorsten

2 Replies
sushil353
Honored Contributor II

Re: Assign colors to certain columns

hi,

Have you tried to set the backgroud color in dimension tab after pressing the + sign corresponding to each dimension.?

if no, then try that option.

HTH

Sushil

sushil353
Honored Contributor II

Re: Assign colors to certain columns

Try the condition as:

=if(Sales_act='act',blue(),if(Sales_act='budg',red(),White()))

HTH

Sushil