topic Re: Custom Format Cells in Straight Table in QlikView

Custom Format Cells in Straight Table

Wed, 09 Sep 2015 21:54:04 GMT

Hi,

I'm trying to change de column header color in a Straight Table with option Custom Format Cell, but it is not working.

Does anyone know if I need to flag any option to make it work ?

*BTW, option Custom Format Cell works well in a Pivot table.

Re: Custom Format Cells in Straight Table

vikasmahajan — Fri, 11 Sep 2015 12:03:03 GMT

Hii,

Soraya Martinez

Select View -> View-Grid View -> right click your straight table select -> Custom Format Cell

and format as per your requirement

Refer screen for more details

HTH

Vikas

Re: Custom Format Cells in Straight Table

vikasmahajan — Fri, 11 Sep 2015 12:03:43 GMT

refer also this Re: Change font color for the titles in straight table

Re: Custom Format Cells in Straight Table

jonoogle — Wed, 10 Oct 2018 21:28:09 GMT

Actually the issue is that in order to be able to format the header, it looks like you to have expression totals. Once you format the cells you can then eliminate them. I believe this is a Qlik bug.

I am attaching an example which explores these possiblities.

1) A straight able with custom color.

2) a chart with no totals and the custom color was set when there were no totals

3) the same as chart (2) but showing the totals of an expression (note the color was put on the totals line)

4) chart where expressions were showing and the custom color was set.

5) chart (4) with expressions now hidden.

Re: Custom Format Cells in Straight Table

jonoogle — Wed, 10 Oct 2018 21:39:18 GMT

See my reply on this thread