topic Re: Text format and colour to the text in script in QlikView

Text format and colour to the text in script

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I need to define a field in script with the below text format

my text format is 'Segoe Script'

and i want to assign a colour to it in the script red

so when ever i call it on the front end it should come as red colur and my text format should be "Segoe Script"

say i created letter

load * inline

[

'A' as myfield,(in the script with Segoe Script format and redcolour to it)

];

output is as below

my field

Re: Text format and colour to the text in script

Anonymous — Mon, 12 Dec 2016 18:55:25 GMT

Setting the font in Setup / Document Property / Font does not work for you?

Re: Text format and colour to the text in script

MK9885 — Mon, 12 Dec 2016 18:58:51 GMT

Why do you need it in script when you can do it in front end as shown by Marcio above. It's much easier where you have no fields to add

Re: Text format and colour to the text in script

Mon, 12 Dec 2016 19:05:55 GMT

yes aravind good question, i know there is a option as shown by marico , but i want only a particualr format of text as field

Re: Text format and colour to the text in script

Anonymous — Mon, 12 Dec 2016 19:34:21 GMT

I made this suggestion because I do not think I can do what you want.

Re: Text format and colour to the text in script

MK9885 — Mon, 12 Dec 2016 20:36:28 GMT

You can use

SET vRed = RGB(128,0,0);

and then use if condition in script to create a field for color.

Temp:

if(A=10,$(vRed)) as RedColor

Resident YourTable Name;

And use Redcolor field in dimensions for Background Color

I do not know how to do for Text Format but this doesn't serve any purpose except we get a fixed color, which can also be given as red() instead of this field.