Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kishoreravi1983
New Contributor II

How to Assign color in Text Object for up Arrow and Down Arrow

This is My Expression:

=' MTD: Overall WW ADM & ITOM License sales were ' & Num($(v$MaxYearTotalOrdersMTD),'##.#') & 'M ' & 'compared with ' & Num($(v$Prev1YearTotalOrdersMTD),'##.#') & 'M ' & 'last year ' & If($(v$MaxYearTotalOrdersMTD)-$(v$Prev1YearTotalOrdersMTD)<=0,chr(9660),chr(9650)) & num(($(v$MaxYearTotalOrdersMTD)-$(v$Prev1YearTotalOrdersMTD))/Fabs($(v$Prev1YearTotalOrdersMTD)),'#.#%')

I need chr(9660),chr(9650)) to be made Red and Green.

Text.JPG

Please can you help me out.

Thanks,

Ravi

3 Replies
el_aprendiz111
Valued Contributor

Re: How to Assign color in Text Object for up Arrow and Down Arrow

Hi,

col.png

kishoreravi1983
New Contributor II

Re: How to Assign color in Text Object for up Arrow and Down Arrow

Thanks Fer, But i would need it in Text Object. Not in Chart. I would like to write a running text as shown in the image.

mdmukramali
Valued Contributor II

Re: How to Assign color in Text Object for up Arrow and Down Arrow

Dear Ravi,

I don't think there is a way to apply formatting to selective text in text object. There is only the one setting that applies to all text in the box.

but you can use multiple text objects and layer them as needed.

Thanks,

Mukram.

Community Browser