topic Re: Color problem when values are null in QlikView

Color problem when values are null

Anonymous — Wed, 03 Feb 2016 16:04:21 GMT

Hi,

I'm trying to color a cell. however, I noticed that where there are some nulls (marked in yellow) it doesn't color at all.

Any ideas how to get over this problem?

for me it seems to be a bug.

Attached is a screenshot:

Re: Color problem when values are null

Wed, 03 Feb 2016 18:21:08 GMT

Can you please share your qvw with sample data. I didn't encounter this issue.

What version of QV you are using ?

Re: Color problem when values are null

Gysbert_Wassenaar — Wed, 03 Feb 2016 18:21:41 GMT

Background color expressions only work on cells that do not have null values. You can try setting a general background that applies to all the dimension cells and overrule it where necessary with the Background Color setting.

Or just use the Custom Format Cell option to set the background color for an entire dimension. You can enable that option in the User Setttings on the Design tab with the Always Show Design Menu Items or by enabling the Grid. Then right click a dimension Cell and choose the Custom Format Cell option

Re: Color problem when values are null

Anonymous — Thu, 04 Feb 2016 08:58:08 GMT

Hi Gysbert,

let me clarify myself - I'm trying to color the 'account_name' column, which is not null, with the red color.

As you can see from my screenshot the second row is colored with red while the first row is not (because of the nulls inkw and sites colomns).

I tried to defined a background color in the custom format cell (see attached screenshot) but it doesn't work well either because I have to select some accounts first.

Any suggestions?

Thanks

Re: Color problem when values are null

Gysbert_Wassenaar — Thu, 04 Feb 2016 17:22:21 GMT

A color expression for the Background Color setting can only return a result for an intersection of dimensions values, just like any other expression. If that result is null it does not matter what value the dimension values have. The result of the expression will be null, so no color value is returned, so the dimension cell will not get a color.

Re: Color problem when values are null

Anonymous — Mon, 08 Feb 2016 15:48:46 GMT

so do you have any idea how to solve it?

Re: Color problem when values are null

Gysbert_Wassenaar — Mon, 08 Feb 2016 16:33:33 GMT

Click on the + in front of the dimension name on the Dimension tab.Click on the Background Color item. Click the Edit button. Enter an expression that calculates a color.

Re: Color problem when values are null

Anonymous — Mon, 22 Feb 2016 13:03:50 GMT

that's exactly what I did. and still it is not working well...

Re: Color problem when values are null

Gysbert_Wassenaar — Mon, 22 Feb 2016 15:54:54 GMT

Post a qlikview document that demonstrates the problem.