topic Re: Workflow for managing font sizes in QlikView

Workflow for managing font sizes

Thu, 18 Jul 2013 06:04:37 GMT

Hi would appreciate any guidance on workflow / techniques to manage font sizes in qlikview charts as it is not obvious to me

I would like to be able to independently size the text for x and y axis labels , x and y axis measures and the data labels on a bar chart.

As it is some are too big and others too small to be legible and there seem to be boxes to control the font in many different places

Thanks in advance

Re: Workflow for managing font sizes

rajni_batra — Thu, 18 Jul 2013 06:12:00 GMT

from Axes tab in ur chart properties you can set font for ur every expression ( x axis and Y axis) and in presentation tab u can set font for ur legend part.

Re: Workflow for managing font sizes

Thu, 18 Jul 2013 06:24:58 GMT

Thanks but still not quite getting it in the example below there is a difference in font between the y axis points and the data label.

If I go into the Axis pane and change the font both of the fonts change but maintain the ratio. Whereas for example I wish to make the x axis text smaller than the data label text. It seems that some of the font controls manage individual elements and others groups.

Sorry if I am not getting something obvious

Re: Workflow for managing font sizes

Thu, 18 Jul 2013 06:53:00 GMT

OK I have done some more playing and think I have it now but if someone can confirm I would be grateful.

So using the above example

Axes - Expressions - Font - Changes the y axis label and the data label font

Axes - Dimensions - Font - Changes the x axis font

Over and above this though you can change the relationship of the y axis and data label fonts as follows

Expressions - expand the expression and select text format - applying the definition '<Hx>' will change the ratio with the y axis remaining fixed whereas

x=4 - ratio is one to one

x>4 - data label is bigger than the y axis

x<4 - data label is smaller than the y axis

Now all that remains is for the data label to auto scale depending on the numbers of columns displayed on the graph !!