Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>')
Thanks a lot
It is working for expression but not for dimension (paid Month) pls help
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.
Is there any other way to do this please.
see the example with your data
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
Yes . But it does not work for Dimension. Can you please attach my sample after modification
Hi,
PFA,
Hirish
Even in the attachment sent by you Dimension(paid month) color is not changed