Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Please can you help me out.
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.
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.