topic Re: Table Columns Colour Confusion? in QlikView

Table Columns Colour Confusion?

Wed, 28 Jan 2015 15:51:44 GMT

Hello all,

I have an existing table with a few dimensions, but mostly expressions. The expression columns all have a grey background for the columns including the totals (but, bot the headers). I added a new expression, but the background colour is white (I can change it to grey in custom formatting). However, when taking a closer look at the other expressions I noticed that I cannot change the background colour, for example when I attempting red it had no affect on the cell. My first thought is there must be a conditional formatting BG colour that I am not spotting.

Has anyone ever run into this problem?

Needless to say this is a dashboard that I've inherited from a previous staff member.

Regards,

Myles

Re: Table Columns Colour Confusion?

crusader_ — Thu, 29 Jan 2015 05:39:57 GMT

Hi,

Can you share this file?

You can leave only this chart and clear all script.

Regards,

Andrei Kaliahin

Re: Table Columns Colour Confusion?

Thu, 29 Jan 2015 14:18:22 GMT

Hi Andrei,

Thank you for responding.

Attach is the bare bones of the chart.

Regards,

Myles

Re: Table Columns Colour Confusion?

Anonymous — Thu, 29 Jan 2015 14:23:56 GMT

You do not seem to have any dimensions or expressions defined in your chart qvw.

Re: Table Columns Colour Confusion?

rubenmarin — Thu, 29 Jan 2015 14:26:41 GMT

Hi Myles, in the expressions tab, you can expand the expressions, in the 'Background color' expression there is the color code to apply to background

Re: Table Columns Colour Confusion?

Thu, 29 Jan 2015 14:34:03 GMT

Thank you very much for solving this for me, Ruben!