topic dynamic text formating in QlikView

dynamic text formating

Anonymous — Mon, 06 Apr 2015 12:25:38 GMT

Hi,

I've created a text object and put some text into it. I've also defined a font color by an expression. I'm using if function to define the color.

I'd like to to use if function to underline the text or NOT underline it. Is it somehow possible?

Thank you in advance,

Larisa

Re: dynamic text formating

Gysbert_Wassenaar — Tue, 07 Apr 2015 10:50:09 GMT

No, that's not possible. Perhaps you can use a line object on top of the text box and show/hide it as needed.

Or use two text boxes. One with the text underlined and one without. Then show/hide the right text box as needed using the Show Conditional option on the Layout tab of the properties window of the text boxes.

Re: dynamic text formating

Anonymous — Tue, 07 Apr 2015 11:42:31 GMT

You could use a "stripped" straight table. Put the text you want to use inside a variable and use this as a Dimension. As an expression you could use this ' ' make sure you select "No Totals" here. On the presentation tab select the "Hide column" option for the expression and select "Suppress Header Row". On the style tab make everything transparent including the background and then go to the caption tab and remove the caption.

You should now have a transparent object that displays your text. Place this on top of a text object to get the color you want.

Now if you go to the dimensions tab you can expand the dimension (plus sign) and edit the text color and the text format with whatever if statements you want. The format for underline is '<U>'.

Re: dynamic text formating

Tue, 07 Apr 2015 12:08:18 GMT

i didn't see it before