topic Re: Header Colours - Straight Table in QlikView

Header Colours - Straight Table

danielnevitt — Wed, 04 Sep 2013 11:12:20 GMT

Hi,

I have read numerous posts relating to changing the colours for the headers in a straight table, however I am still have trouble achieving exactly what I want.

I have 1 dimension and then 8 expressions and I would ideally like to be able to set a different colour for each column.

I have selected the 'Always Show Design Munu Items' on the Design tab in user preferences and also selected Advanced in the Styling Mode in the Document Properties. However I am only able to change the colours of all the column headers, rather than a specific colour for each header.

Any help with this will be much appreciated.

Thanks,

Daniel

Re: Header Colours - Straight Table

cesaraccardi — Wed, 04 Sep 2013 11:19:29 GMT

Hi Daniel,

Try this: Enable the Design Grid, then right click on your straight table and select "Custom Format Cell". This will show a dialog to set background/font colors, I am not sure but I think you are able to select individual colors for your expressions and dimensions.

Hope that helps,

Cesar

Re: Header Colours - Straight Table

michael_maeuser — Wed, 04 Sep 2013 11:22:44 GMT

with the "custom format cell" it´s not poosible to give each column a different color, as far as i know.

as daniel wrote, you can select colors for dimensions and expressions but not a different color for each expression. try it in the object properties with "visual cues". this way at least works as long as your header is text and the lines are numbers...

Re: Header Colours - Straight Table

Wed, 04 Sep 2013 11:26:54 GMT

You can't change the colors of the individual column labels. You can change the color of all of them together. You can change the color of individual cells for totals. And you can change the background color of individual columns.

To change customize the cells first enable the option Always Show Design Menu Items on the Design tab of the user preferences window. Then in the chart right click the cell you want to customize and choose Custom Format Cell.

Re: Header Colours - Straight Table

danielnevitt — Wed, 04 Sep 2013 11:28:17 GMT

Hi,

Thanks for both the responses.

Cesar - I have tried that suggestion and I can only change all the column headers to the same colour. There is a box stating 'Apply change to', but the only drop down option is All Dimensions

Michael - How can I just change the header cell colour, rather than all the cells in that column, using visual cues?

Thanks,

Daniel

Re: Header Colours - Straight Table

michael_maeuser — Wed, 04 Sep 2013 11:48:12 GMT

select your expression and only change the background color for text. but like i mentioned, only works if you don´t have text in your lines. that´s unfortunately all you can do

Re: Header Colours - Straight Table

michael_maeuser — Wed, 04 Sep 2013 11:55:48 GMT

did that work for you or do you have text in your lines?

Re: Header Colours - Straight Table

danielnevitt — Wed, 04 Sep 2013 11:59:41 GMT

Hi Michael,

If I change it for a text field, it only changes the rows and not the header.

If I change it for a numeric field, it doesn't change anything.

Regards,

Daniel

Re: Header Colours - Straight Table

michael_maeuser — Wed, 04 Sep 2013 12:04:07 GMT

sorry, you have to change it to a pivot table

Re: Header Colours - Straight Table

Gysbert_Wassenaar — Wed, 04 Sep 2013 12:05:07 GMT

See this post for what's possible.

Re: Header Colours - Straight Table

Sat, 29 Aug 2015 11:45:46 GMT

Hi,

yes, it is possible to change the colour of particular headers in straight table, but it's a bit confusing to understand, but it works

See here to find the solution:

Regards, K