topic Re: How to make single field bold in QlikView

How to make single field bold

Tue, 29 Jul 2014 08:04:07 GMT

Hello everyone,

I have following Table,

G1	G2	Gtotal	Month
2	5	7	Apr
3	2	5	May
4	1	5	Jun
5	4	9	Jul

I want to make bold only Gtotal Field and its value.Could anyone provide me the syntax to bold this field to put in text format of the expression.

Thanks in advance

Re: How to make single field bold

its_anandrjs — Tue, 29 Jul 2014 08:09:24 GMT

For this use option Custom Format Cell and right click on the chart column for that and from option Custom Format Cell you change column as bold and check this option is enable or not from Properties >> User preference >> Design >> and enable Always Show Design Menu Items.

Re: How to make single field bold

Anonymous — Tue, 29 Jul 2014 08:10:37 GMT

Hi,

Go to chart properties --> expression tab --> click on "+" sign --> go to Text Format --> ''

Re: How to make single field bold

its_anandrjs — Tue, 29 Jul 2014 08:15:48 GMT

And there is another option by click on plus sign in expression and write '' or '' B for Bold and I for Italic

And even you use

For Italic

For Bold

For Underline

Re: How to make single field bold

Tue, 29 Jul 2014 08:18:35 GMT

Project	Apr	May	Jun
G1	2	9	8
G2	3	6	1
Gtotal	5	15	9
A1	8	5	4
A2	6	4	2

Sorry guys I want to make change in the table which I shared,The table is like above where issue is to bold Gtotal which sum the value of G1 and G2 in excel ,so this row must be bold.

Re: How to make single field bold

aveeeeeee7en — Tue, 29 Jul 2014 08:19:46 GMT

Use ''

or custom Format Cells.

For Custom Format Cell do the following Setting:

1. Ctrl+Shift+U or Simply Go to Settings > User Preferences and then move to Design Tab > Check the Option "Always Show design Menu Items" > The Chart on which you have to make the Colored rows > Right Click on it > There you see the Option Custom Format Cells > From there you can change colors, format, etc.

Regards

Aviral Nag

Re: How to make single field bold

Tue, 29 Jul 2014 08:21:37 GMT

It's also worth saying bhawna, if you are just looking to bold the expression, either of the two above will work for you.

However if the bold needs to be applied based on a criteria, the text format from the expression will need to be used

hope that helps

Joe

Re: How to make single field bold

its_anandrjs — Tue, 29 Jul 2014 08:22:38 GMT

Then try like

if(Project = 'Gtotal', '')

By click plus sign in Text format option of the expression.