Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor II

Re: Conditionally formatting a value in a straight table?

Hi,

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

Similarly can be done for dimension

HTH

Sushil

8 Replies
sushil353
Honored Contributor II

Re: Conditionally formatting a value in a straight table?

Hi,

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

Similarly can be done for dimension

HTH

Sushil

Not applicable

Re: Conditionally formatting a value in a straight table?

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

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

Not applicable

Re: Conditionally formatting a value in a straight table?

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

Re: Conditionally formatting a value in a straight table?

bump

sushil353
Honored Contributor II

Re: Conditionally formatting a value in a straight table?

use somethig like

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

edit dimension.

HTH

Sushil

Not applicable

Re: Conditionally formatting a value in a straight table?

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

neetha_p
Honored Contributor

Re: Conditionally formatting a value in a straight table?

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
New Contributor

Re: Conditionally formatting a value in a straight table?

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.

Community Browser