topic Color coding for certain field in QlikView

Color coding for certain field

Wed, 08 Jul 2009 20:58:22 GMT

Hi everyone,

I am trying to make mapping for color coding in one field and so far no luck. I want to have colors for values of this dimension override default setting (as I understood default color coding is based on load order).

The only thing that worked was to sort field values in Excel file, sort them in some way, and make Default Colors in the document in that order.

Is there any other way to do this just for one field?

Regards

Color coding for certain field

disqr_rm — Thu, 09 Jul 2009 02:00:23 GMT

You can expland the + under dimension field you are interested in and under respective area you can code however you want. You can code it like: if(value = 0, red(), blue()) or so. Under text formatting you can also specify things like: if(value = 0, '<B>') to make it bold.

Hope I answered what you are looking for. Otherwise, just upload a sample of what you are trying to achieve.

Color coding for certain field

Thu, 09 Jul 2009 15:12:03 GMT

Hi Rakesh,

Thanks for the idea. I tried that, but it takes too much coding on each chart, for every value and so on. And I didnt manage to get it to work quite right 🙂

I tried to load RGB values in separate fields and set color dynamicaly like that, but its not working neither in Dimensions or Expressions page the way I hope to make.

Heres how I tried.

1) First, there is this Excel file with Item Type values and Colors that should represent them. This is loaded before actual values from DB.

2) Second step is to change Document Default Colors to match those from Excel file

3) Now the chart looks like something like this

Ok, so it works for this simple scenario. But if I wanted to make similar Color Coding (with different colors 1,2,3 ..) also for, for examle, Customer groups, that couldnt be done this way. I hope to make it work across whole application.

Ideal solution would be to have the ability to have individual color page for every field, so default setting could be changed on micro level. Is this available?