topic Re: Unable to change font size on data values in QlikView

Unable to change font size on data values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Unable to change font size on data values

trdandamudi — Mon, 06 Aug 2018 19:47:56 GMT

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

Re: Unable to change font size on data values

Anonymous — Mon, 06 Aug 2018 19:53:10 GMT

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

Re: Unable to change font size on data values

vishsaggi — Mon, 06 Aug 2018 21:15:31 GMT

May be you are missing > for H1 so try like

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

Re: Unable to change font size on data values

Anonymous — Mon, 06 Aug 2018 23:27:04 GMT

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

Re: Unable to change font size on data values

Anonymous — Mon, 06 Aug 2018 23:28:10 GMT

This cant be done.

Re: Unable to change font size on data values

vishsaggi — Mon, 06 Aug 2018 23:55:41 GMT

‌Is col a field name or a calculated expr?

Re: Unable to change font size on data values

Anil_Babu_Samineni — Tue, 07 Aug 2018 02:56:12 GMT

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?

Re: Unable to change font size on data values

vishsaggi — Tue, 07 Aug 2018 03:23:57 GMT

‌pput quotes around the value Y like

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

Re: Unable to change font size on data values

pooja_prabhu_n — Tue, 07 Aug 2018 05:56:13 GMT

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.

Thanks,

Pooja

Re: Unable to change font size on data values

Anonymous — Tue, 07 Aug 2018 12:40:39 GMT

Just to answer some of the questions posted earlier for me.

The example I gave in above are fields coming from the database. There are more fields than

what's shown. These fields along with the data are rendered in a Straight Table. So for what I was asking

and wanted to accomplish, I want to enlarge the font size for the entire row (for however many fields

there are) for specific condition - ie when Col=Y. I want this row to be visually distinctive from the rest.

Looks like I can't do it based on your replies.

Any other tricks