topic Remove "set by style" in object font properties in QlikView

Remove "set by style" in object font properties

blaise — Mon, 11 Apr 2011 10:23:42 GMT

How the hell do I remove the "set by style" in the objects font properties? I have searched reference manual as well as the forum for an answer. Custom Format cell is not an answer, i simply want to remove the "set by style" so I can change font color and font style (bold, italic etc) for the objects. Im going crazy over this, spend 1 hour trying to find the setting in object, document and user properties without any luck. Br Blaise

Remove "set by style" in object font properties

nathanfurby — Mon, 11 Apr 2011 10:30:16 GMT

I don't know what the Set by Style actually means... but what are you trying to achieve?

Remove "set by style" in object font properties

Tue, 20 Sep 2011 20:22:57 GMT

Did you ever get an answer to this question? I am new to qlikview and struggling with the same problem (probably caused by my ignorance) but now I cannot find how to override the "set by style" limitation on the fonts! Very irritating!

Remove "set by style" in object font properties

Anonymous — Mon, 05 Dec 2011 10:06:57 GMT

I have this problem aswell! any solution yet?

Remove "set by style" in object font properties

Tue, 06 Dec 2011 16:26:50 GMT

I am having this problem as well. In an object properties, on the Font tab, I can not use any other option except "Set by Style". I would like to override this. Did any of you find a solution? Thanks.

Remove "set by style" in object font properties

Anonymous — Wed, 07 Dec 2011 06:59:49 GMT

i used the text color and text format setting in experssion to work around it. and then the right clikc option "format cell" to adjust the headers.

hope that helpes you!

Remove "set by style" in object font properties

Wed, 07 Dec 2011 09:11:55 GMT

Yep, that seems to do the trick (as a workaround).

Thanks!

Re: Remove "set by style" in object font properties

Thu, 07 Feb 2013 16:35:31 GMT

I am having the same issue, can you explain your work around in more detail?

It's using a chart - straight table, and the font will not allow anything except "set by style".

Thanks for any help!

Re: Remove "set by style" in object font properties

blaise — Mon, 18 Feb 2013 09:57:51 GMT

In the expression tab you have a list of all your expressions to the right, there is a + sign before each expression. Press this + sign to expand the possible settings.

type '<b>' in the text format for BOLD text, '<i>' for ITALIC, to give some examples.

In the text color you can use either built-in function like white() or rgb(). Refer to reference manual for a complete list of all available settings.

Re: Remove "set by style" in object font properties

Mon, 18 Feb 2013 14:58:44 GMT

Awesome, thank you! Perfect explanation.

I actually found another post that mentioned going to the menu View - Design Grid, then right clicking any cell and making the format change to the individual cell or applying to the dimension. This also worked.

Re: Remove "set by style" in object font properties

blaise — Mon, 18 Feb 2013 15:01:22 GMT

Yes, the problem is that you might lose your format change if you later on change the style (object properties) to one of the pre-defined. By applying a custom format cell the style gets set to custom.

Its possible to change the dimension color, bg color and format the same way as the expressions.

I find this solution more robust than doing a custom format cell.

Re: Remove "set by style" in object font properties

Fri, 17 Jan 2014 09:32:52 GMT

It may have been set by Custom Format Cell

Activate Grid View (View>Design Grid) then right click on the cells and columns in the table and select Custom Format Cell. You may need to change a few dims/cells. Unfortunately I do not have a means of reseting to give 'control' back to the object properties.