Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to change font size on data values

Hi,

I am trying to set the "Text Format" to increase the font size on a particular data (or the specific cell) in a straight table.

For example, let's say I have this table for simplicity:

Status       Col

-----------------------------------

Success    N

Failed        Y

------------------------------------

Then, in my Text Format for the "Status" field, I have something like this:

=IF(Col=Y, '<B><I><H1')

I am getting bold and italic but not font size.

How do I do this or what's the syntax for this?

Thanks

10 Replies
trdandamudi
Master II
Master II

I don't think you can increase the font size...

Anonymous
Not applicable
Author

Please take a look at this link:

Resizing text / font size of Values on Data Points / Bar

It looks like it's possible but I can't get it to work

vishsaggi
Champion III
Champion III

May be you are missing > for H1 so try like

=IF(Col=Y, '<B><I><H1>')

Anonymous
Not applicable
Author

Sorry I missed the closing angle bracket.  So I did have it.

Anonymous
Not applicable
Author

This cant be done.

vishsaggi
Champion III
Champion III

‌Is col a field name or a calculated expr?

Anil_Babu_Samineni

Headed concept won't work like H1...6 due to HTML concepts(Alone will work). Instead why not to use Font tab in your object properties?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vishsaggi
Champion III
Champion III

‌pput quotes around the value Y like

=IF(Col=‘Y’, '<B><I><H1>')

pooja_prabhu_n
Creator III
Creator III

Hi,

It is not possible to change the font size in straight table, but H1 to H6 works for value on data points in bar or line chart.

You can try using custom Format cell option. But, it will apply for the current expression not for one row.

12.PNG

Thanks,

Pooja