topic Re: How to change text colour in rows in a dimension in QlikView

How to change text colour in rows in a dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How do I change the text colour to red in two of the rows in the following table -

I would like to always highlight the 'Distance Learning', and 'Other open...' rows in red text.

Thanks

Greg

Re: How to change text colour in rows in a dimension

sunny_talwar — Wed, 22 Feb 2017 12:58:57 GMT

Use background color for your dimension. Did that not work?

Re: How to change text colour in rows in a dimension

Anonymous — Wed, 22 Feb 2017 13:16:17 GMT

I assume I would use the background colour on the dimension, but how do I change the text colour for just two of the rows in the dimension?

Thanks

Re: How to change text colour in rows in a dimension

sunny_talwar — Wed, 22 Feb 2017 13:18:39 GMT

Using an if statement...

If(WildMatch(DimensionName, 'Distance Learning', 'Other open learning*'), LightRed())

Re: How to change text colour in rows in a dimension

jonathandienst — Wed, 22 Feb 2017 13:23:25 GMT

Use an expression like:

If(Match([Mode of attendance], 'Distance Learning', 'Other....'), Red())

Just adjust the field and conditions in the match to your requirements.

Re: How to change text colour in rows in a dimension

Anonymous — Wed, 22 Feb 2017 13:26:44 GMT

Thanks very much

Re: How to change text colour in rows in a dimension

Anonymous — Wed, 22 Feb 2017 13:52:48 GMT

Why isn't the 'Other open learning...' field showing as red text in the following table?

I think it is because the first data column in the table has no value for the 'Other open learning...' row, eben though there are values in data columns 2 and 3.

How do I fix it to always show red?

Thanks

Re: How to change text colour in rows in a dimension

sunny_talwar — Wed, 22 Feb 2017 13:54:56 GMT

Try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps

Re: How to change text colour in rows in a dimension

sunny_talwar — Wed, 22 Feb 2017 13:55:32 GMT

Also did you Match or WildMatch? Can you share the expression you used?

Re: How to change text colour in rows in a dimension

Anonymous — Wed, 22 Feb 2017 13:58:28 GMT

Thanks , that worked but it replaced the '-' with'0'

Re: How to change text colour in rows in a dimension

sunny_talwar — Wed, 22 Feb 2017 14:01:51 GMT

May be use Dual statement for your expression

Dual(If(Expression = 0, '-', Expression, Expression)

and then choose 'Expression Default' on number's tab for number formatting