topic why does this RGB function not work? in QlikView

why does this RGB function not work? (sample now included)

amien — Tue, 05 Jan 2010 10:03:55 GMT

=IF(NodeActive='N',RGB(10,10,10),RGB(70,130,180))

i only see the second color in my dimensions.

When i select only the NodeActive=J in a listbox .. then i only see the first color. But with no selection i see only the second color.

Thanks in advanced

why does this RGB function not work?

Tue, 05 Jan 2010 10:25:46 GMT

The expression itself looks ok to me.
Do you have the field NodeActive as a dimension in your table?
If not, you probably get multiple values for that field when you don't have any selections.

/Fredrik

why does this RGB function not work?

Tue, 05 Jan 2010 10:44:26 GMT

With no value selected, then the value of NodeActive is undefined (null). So with no selection you would expect to see the second colour.

Regards,

Gordon

why does this RGB function not work?

amien — Tue, 05 Jan 2010 11:32:02 GMT

the IF function is in a dimension ... not an expression. so there shouldnt be any multible values.

gorden . i understand what you mean.. but how can i make this work with no selection?

why does this RGB function not work?

Miguel_Angel_Baeyens — Tue, 05 Jan 2010 11:33:00 GMT


Amien wrote:When i select only the NodeActive=J in a listbox .. then i only see the first color. But with no selection i see only the second color.

That's correct, because when no selections are done, NodeActive=N is false. Check as well current selection in the conditional, something like

if(NodeActive='N' AND GetFieldSelections(NodeActive) >= 1, RGB(10, 10, 10), RGB(70, 130, 180))

Change that depending on which colour do you want to see by default.

why does this RGB function not work?

amien — Tue, 05 Jan 2010 11:40:37 GMT

but i want to change to color based on no selection .. value is in a dimension

why does this RGB function not work?

Miguel_Angel_Baeyens — Tue, 05 Jan 2010 13:33:59 GMT

For what it's worth, I suppose you mean you are drawing a chart (straight table, pivot table) and you want to change background colours? Please, specify your case. A dimension is a field, so your conditional should be based on fields, as well as it's possible to do it by checking value of a field, selection... where do you want to apply that color change?

why does this RGB function not work?

amien — Tue, 05 Jan 2010 13:59:50 GMT

companies are in the dimenisions .. i want the background of that company to be red if its not active anymore. if a company is active of not is based on the fieldNodeActive.. Working with the hierarcy function .. so i have some levels of companies as dimension.

i want to apply the color change in pivot .. in used dimensions and then in background color of a certain dimension

why does this RGB function not work?

amien — Tue, 05 Jan 2010 21:58:19 GMT

this is an example .. seems a hierarchy issue ... i'v created a normal pivot with rgb background color change for dimensions .. and one for a hierarchy function. Help really appropriated.

why does this RGB function not work?

Anonymous — Wed, 06 Jan 2010 05:44:25 GMT

Hi Amien,

If you add an expression to the left chart, Active, you will see that all the values for Base = Base2 return No. If you do the same on the right chart and add the expression, Active_Hier, you'll see that the only row for Base2 that has Active_Hier=No is the one where it lacks a Node value in L2. Since there are two different values, Yes and No, the background color expression will determine that the value of Active_Hier is NOT No and hence the dimension background color will not be red.

There are man ways to skin a cat but if you only have values Yes and No for Active_Hier then you should be able to check for a minstring() to see if at least one of the values is 'No' and in that case color the dimension background.

Example:

=IF(aggr(minstring(Active_Hier),HQ, L1)='No',Red(),White())

why does this RGB function not work?

amien — Sat, 30 Jan 2010 00:34:12 GMT

with L2 i do

=IF(aggr(minstring(Active_Hier),HQ, L2)='No',Red(),White()) .. right? i always refer to the first dimension?

what if Active_Hier contains two options .. and i want to prefer one of the options ..

so if active_hier has two options, when the cell should be white() .. if there is one option and the value is 'no' then it should be red. if there is one option and this option is 'yes' can bg-color is red.

so really .. if there is only 1 option and that option is red, when bg-color is red. in all other cases it should be white