topic Conditionally formatting a value in a straight table? in QlikView

Conditionally formatting a value in a straight table?

Thu, 07 Mar 2013 09:02:48 GMT

Hi Guys

I have a straight table- I want to be able to change the background color of a cell within a dimension if a particular value is present.

Can anyone help?

Thanks

Re: Conditionally formatting a value in a straight table?

sushil353 — Thu, 07 Mar 2013 09:29:28 GMT

Hi,

Please find attached file. here you can set condition in Expression>background.

Similarly can be done for dimension

HTH

Sushil

Re: Conditionally formatting a value in a straight table?

Thu, 07 Mar 2013 09:30:08 GMT

Expand axis that you've added, select Background color and edit its formula like this:

=If(YOURAXISNAME='XXX', Red(), White())

Re: Conditionally formatting a value in a straight table?

Thu, 07 Mar 2013 15:15:30 GMT

These are really helpful! Thank you

I have one more quick question.

How do I format a dimension as a % within a straight table and how do I format a dimension that currently shows 800000 as 800,000

I can only see how I would do this if it is an expression.

Thank you in advance

Re: Conditionally formatting a value in a straight table?

Thu, 07 Mar 2013 19:43:17 GMT

bump

Re: Conditionally formatting a value in a straight table?

sushil353 — Fri, 08 Mar 2013 06:06:23 GMT

use somethig like

=num(fieldname,'##0.0%')

edit dimension.

HTH

Sushil

Re: Conditionally formatting a value in a straight table?

Fri, 28 Nov 2014 19:19:12 GMT

i have list report with out any expression how can i make conditional formatting based on "YES" and NO

if it is NO back ground should be RED

Re: Conditionally formatting a value in a straight table?

Anonymous — Fri, 28 Nov 2014 19:30:00 GMT

Hi Mohammed,

You can create an empty expression and in background color - give condition or you can give in dimension - background color the condition.

Regards

Neetha.

Note: please start new thread for new query's.

Re: Conditionally formatting a value in a straight table?

justaqlikker — Thu, 11 Aug 2016 12:41:18 GMT

Thank you. This is wonderful. I am now able to get perfect conditional formatting to be able to highlight outliers or invalid data. Also, I use this to highlight rows of net totals which I calculate and even to create alternating shading in a table in order to improve readability.