topic Formatting text programatically in QlikView

Formatting text programatically

Tue, 28 Jul 2009 22:31:08 GMT

Is there any way to change the font and/or color of the text in a text object programatically or is the text sigularly formatted for the entire object?

I am imagining an expression that might look something like this.....

=FIELDNAME1 & bold(' - this text should be bold') & chr(13) & italics(FIELDNAME2) & red('this text should be red')

Formatting text programatically

Gustav_Guldberg — Tue, 28 Jul 2009 23:13:25 GMT

Marc,

I'm pretty sure you can't. I've never been able to and I haven't seen a working example (please prove me wrong here and upload an example if you have one).

You could post this as an idea and we might see this in an upcoming release.

Regards,

Gustav

Formatting text programatically

disqr_rm — Tue, 28 Jul 2009 23:17:18 GMT

Nope, I don't think you can do this. You are better off with putting a streight table instead. Use separate dimensions where you need to change the formatting, and '1' as the expression. Then hide this expression column in the presentation tab.

With your example above, I would think you would create 4 dimensions. You may have to use MAX or MAXSTRING on the FIELDNAME if it may consist mutiple values. Then you can format these cells/columns accordingly.