Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditionally formatting a value in a straight table?

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

1 Solution

Accepted Solutions
sushil353
Master II
Master II

Hi,

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

Similarly can be done for dimension

HTH

Sushil

View solution in original post

8 Replies
sushil353
Master II
Master II

Hi,

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

Similarly can be done for dimension

HTH

Sushil

Not applicable
Author

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

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

Not applicable
Author

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

Not applicable
Author

bump

sushil353
Master II
Master II

use somethig like

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

edit dimension.

HTH

Sushil

Not applicable
Author

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

Anonymous
Not applicable
Author

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.

justaqlikker
Contributor III
Contributor III

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.