Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
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

Highlighted
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