topic Re: Straight Table Font Change in QlikView

Straight Table Font Change

dwfiv327 — Thu, 20 Sep 2018 13:17:45 GMT

I have a straight table for which I want to do some special formatting. One column has a date value. If it is blank, I want the rest of the row to have a different background color and to be larger. I can get the color changed by going to Expressions or Dimensions tab, expanding the + in front of the expression or dimension and entering =if(ResDate=' ',Green()) in the Background Color dialog.

What function or value to I put in the Text Format dialog to change the font size?

Re: Straight Table Font Change

stigchel — Thu, 20 Sep 2018 13:22:11 GMT

You can use these

//Expression Attributes text format

'<B>' =BOLD

'<I>' =ITALIC

'<H1>' =Bigger Font

'<H6>' =Smaller Font

Re: Straight Table Font Change

dwfiv327 — Thu, 20 Sep 2018 13:35:35 GMT

<B> works but <H1> does not.

Re: Straight Table Font Change

stigchel — Thu, 20 Sep 2018 14:07:19 GMT

Hmm, I can remember it working sometime, this came from my notes I keep. Now, I can't get it to work either and a search came up empty, sorry

Re: Straight Table Font Change

rwunderlich — Thu, 20 Sep 2018 14:18:23 GMT

According to the help

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Straight_Table.htm

only <B>, <I> and <U> are available.

-Rob

Re: Straight Table Font Change

Frank_Hartmann — Thu, 20 Sep 2018 14:21:35 GMT

As far as I remember the '<H1>' only works for values on datapoints in line/bar chart.

If you need to increase the font you will have to use custom format cell:

View --> Design Grid then right click on the straight table and then there is the option custom format cell available.

Re: Straight Table Font Change

dwfiv327 — Thu, 20 Sep 2018 14:31:00 GMT

Tried View-->Design Grid and it behaves weirdly. When I select the cell I want to format, it formats every other row to match! (So one big, one small, one big, one small and so on.) I want to conditionally format any cell that meets a certain criteria.

Thanks for pointing out Design Grid anyway. I didn't even know that function existed!

Re: Straight Table Font Change

Frank_Hartmann — Thu, 20 Sep 2018 14:34:03 GMT

with custom format cell you can only apply the format either to dimension or to expression or to dimension and expression!

Re: Straight Table Font Change

stigchel — Thu, 20 Sep 2018 14:35:32 GMT

Ah that was it, couldn't remember