topic Re: Color change in single cell in QlikView

Color change in single cell

Fri, 29 Jan 2016 12:35:22 GMT

My requirement is to change text color to red where value is negative..But since all the values occur in same cell when i change the text color all three values become red .Only -76.69 should change to red

Expression used is as follow:-

=dual(

num((Sum({<CalendarYear={"$(vMaxYear)"}>}Sales))/(Sum(Total {<CalendarYear={"$(vMaxYear)"}>}Sales)), '0.00%')&chr(10)&''

& ' ' & num(Sum({<CalendarYear={"$(vMaxYear)"}>}Sales), '###,##0')

& ' ', Sum ({<CalendarYear={"$(vMaxYear)"}>}Sales)

) &' ' & chr(10) & ' '& (num((((Sum({<CalendarYear={"$(vMaxYear)"}>}Sales))

(Sum({<CalendarYear={"$(vPrevYear)"}>}Sales)))

Sum({<CalendarYear={"$(vPrevYear)"}>}Sales)),'0.00%')

Re: Color change in single cell

Colin-Albert — Fri, 29 Jan 2016 17:02:19 GMT

You can set the text and background colour by clicking on the [+] next to the expression in the Chart Properties, Expressions tab, and then select which parameter you wish to change.

You can use expressions to set different background colours etc.

Re: Color change in single cell

Colin-Albert — Fri, 29 Jan 2016 17:04:55 GMT

Also look at the Visual Cues on the chart Properties