EXPRESSION FORMAT

[upaliwije]

In my attached QV I have  formatted the Expression and Dimension . But is not working. Kindly have look at it and advise where I have gone wrong

[Gysbert_Wassenaar]

PAID_MONTH = 'MAY,JUN,JUL'

That test is PAID_MONTH is equal to the entire string 'MAY,JUN,JUL'. It does not test if PAID_MONTH is one of 'MAY', 'JUN' or 'JUL'. Next, the PAID_MONTH values in your document are 'May', 'Jun' and 'Jul'. NOT 'MAY', 'JUN' and 'JUL'. Make sure to use the exact case sensitive values.

Finally '<R>' is not a color. You need to use one of the color functions like LightRed(), Red(), RGB(255,0,0) that returns the numeric value of a color.

Try these:

Text Color: =if(match(PAID_MONTH,'May','Jun','Jul') , LightRed())

Text Format: =if(match(PAID_MONTH,'May','Jun','Jul') , '<B>')

[upaliwije]

Thanks a lot

It is working for expression but not for dimension (paid Month) pls help

[Gysbert_Wassenaar]

Then your expression for the dimension Text Format contains a typo. It's impossible for the same expression to work for the expression, but not work for the dimension.

[upaliwije]

Is there any other way to do this please.

[ecolomer]

see the example with your data

[HirisH_V7]

Is this what you require means,

you can use same text color and text format expressions for  your dimension too As gwassenaar‌ Suggested.

HTH,

Hirish

[upaliwije]

Yes . But it does not work for Dimension. Can you please attach my sample after modification

[HirisH_V7]

Hi,

PFA,

Hirish

[upaliwije]

Even in the attachment sent by you Dimension(paid month) color is not changed