topic Re: EXPRESSION FORMAT in QlikView

EXPRESSION FORMAT

upaliwije — Sun, 14 Feb 2016 11:00:17 GMT

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

Re: EXPRESSION FORMAT

Gysbert_Wassenaar — Sun, 14 Feb 2016 11:08:30 GMT

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>')

Re: EXPRESSION FORMAT

upaliwije — Sun, 14 Feb 2016 11:14:43 GMT

Thanks a lot

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

Re: EXPRESSION FORMAT

Gysbert_Wassenaar — Sun, 14 Feb 2016 11:20:52 GMT

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.

Re: EXPRESSION FORMAT

upaliwije — Sun, 14 Feb 2016 11:27:33 GMT

Is there any other way to do this please.

Re: EXPRESSION FORMAT

ecolomer — Sun, 14 Feb 2016 11:28:28 GMT

see the example with your data

Re: EXPRESSION FORMAT

HirisH_V7 — Sun, 14 Feb 2016 11:57:03 GMT

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

Re: EXPRESSION FORMAT

upaliwije — Sun, 14 Feb 2016 13:17:34 GMT

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

Re: EXPRESSION FORMAT

HirisH_V7 — Sun, 14 Feb 2016 14:02:33 GMT

Hi,

PFA,

Hirish

Re: EXPRESSION FORMAT

upaliwije — Sun, 14 Feb 2016 14:07:26 GMT

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

Re: EXPRESSION FORMAT

HirisH_V7 — Sun, 14 Feb 2016 14:43:39 GMT

Hi ,

I can see the table like this,

in the same app.

Which version of QV your'e Using!!