topic Re: Percent Sign Trouble in QlikView

Percent Sign Trouble

Tue, 11 Feb 2014 15:02:09 GMT

I am showing a Percentage using =NUM( SUM( IF ( Field1 > variable,1,0 ) )/ Count( Distinct Trips ),'##%') as my expression.

The font style I have selected is Arial Bold size 36.

This produces a good size number which is what I am looking for, but I do not like that the % symbol is also so large.

Does anyone know how I can shrink it down and still leave it as part of the expression?

Re: Percent Sign Trouble

Miguel_Angel_Baeyens — Tue, 11 Feb 2014 15:17:20 GMT

Hi Jeremy,

The short answer is that you cannot. Everything within the same text object will have the same size. So if you want to somehow "customize" the size of individual items you will have to use for example additional text objects with smaller font sizes (or extensions, of course).

Miguel

Re: Percent Sign Trouble

MK_QSL — Tue, 11 Feb 2014 15:19:31 GMT

Create two different expression, If you using this in Text Box

=NUM( SUM( IF ( Field1 > variable,1,0 ) )/ Count( Distinct Trips ),'##,##')/100

and

One More Simple text box with only % inside it.

Now put this 2nd text box on the top of 1 so that it will appear after number...

also make sure the second text box should be having TOP layout

This can be done by select TOP from Layout tab.

Re: Percent Sign Trouble

Peter_Cammaert — Tue, 11 Feb 2014 15:21:48 GMT

No, since settings like font and size apply to expression output as a whole.

Your question is sparse on details of the context. IS your expression used in a text box? In a Pivot/Straight table? In a caption?

In a Straight table, you could define a second column with fixed content (just a %) that is left aliigned. Text properties for the '%'-column can then be tuned using the Custom Format Cell-dialog (i.e. text size can be reduced to 80%) You can remove the cell border between the two as well.

Best,

Peter

Re: Percent Sign Trouble

Anonymous — Tue, 11 Feb 2014 15:22:41 GMT

... and vote here: http://community.qlik.com/ideas/1880

Re: Percent Sign Trouble

Miguel_Angel_Baeyens — Tue, 11 Feb 2014 15:27:24 GMT

Done!

Re: Percent Sign Trouble

Anonymous — Tue, 11 Feb 2014 15:29:39 GMT