Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

josephinetedesc
Contributor III

Is it possible to bold a heading?

Hi

I have done partial sums and now get the Totals and i am happy with this - but is it possible to highlight the total row and the total column?

Jo

DateLocationTotallocaLocbLocclocdloce
Total 0.8%1.2%0.7%0.8%1.1%0.4%
Apr 2015#1.5%3.2%0.8%1.2%2.0%0.4%
May 2015#1.9%0.4%0.6%1.3%4.5%0.9%
Jun 2015#2.5%3.0%1.4%3.0%2.5%1.2%
Jul 2015#2.5%1.6%4.2%2.2%2.2%2.8%
Aug 2015#3.2%11.4%0.7%2.0%3.4%0.1%
Sep 2015#1.4%1.7%1.7%1.6%1.7%0.1%
Oct 2015#1.5%0.6%2.0%1.6%2.0%0.7%
Nov 2015#0.6%-0.6%0.8%0.7%0.2%
1 Solution

Accepted Solutions

Re: Is it possible to bold a heading?

Hi Josephine,

Right click on the chart, there you will see custom format cell option. Give a try.

Capture.PNG

Let me know.

5 Replies

Re: Is it possible to bold a heading?

Hi Josephine,

Right click on the chart, there you will see custom format cell option. Give a try.

Capture.PNG

Let me know.

lastgoodusernam
New Contributor III

Re: Is it possible to bold a heading?

If in a chart, for each loca - loce column select the + symbol next to the expression and select Background Color. Enter the following formula in the Definition box:

=if(Dimensionality()=0,Red())

Where Red() can be any predefined color or RGB(x,x,x)

In the Total column enter:

=if(Dimensionality()=0,Red(),Yellow())

This will color the Total column yellow and the Total row red.

MVP
MVP

Re: Is it possible to bold a heading?

Hi,

Try like this

1. Press Ctrl + G to enable Design Grid option

2. Now right mouse click on the header and select Custom Format Cell option

3. Now apply the required font styles and give OK

HOpe this helps you.

Regards,

Jagan.

josephinetedesc
Contributor III

Re: Is it possible to bold a heading?

thank you - i tried and tried ... but it seems to be a very particular small area and then you get the properties for the cell.... But once I found it I could not see what the trouble was

josephinetedesc
Contributor III

Re: Is it possible to bold a heading?

ah I now see why you need to do Control G (without Control G - you cannot even get to the particular small area and then get the properties showing the format of the cell!

Community Browser