topic Re: Make a condition on a cell value in a simple table in Integration, Extension & APIs

Make a condition on a cell value in a simple table

Frédéricdh — Wed, 12 Jul 2023 08:18:09 GMT

How to make a condition on a cell value in a simple table.

Re: Make a condition on a cell value in a simple table

Chirantha — Wed, 12 Jul 2023 08:39:44 GMT

Hey Frédéricdh,

You can use a background color expression to apply conditional formatting to the cells in a table based on their values. Here’s how you can do it:

In the table’s properties panel, go to the column that you want to apply the condition to and expand its properties by clicking on the arrow next to its name.
Scroll down to the Background color section and click on the fx button to open the expression editor.
Enter an expression that defines the background color of the cell based on its value. For example, if you want to highlight cells with a value greater than 100 in green, you can use the following expression:

if([ColumnName] > 100, green())

Re: Make a condition on a cell value in a simple table

Frédéricdh — Wed, 19 Jul 2023 06:45:32 GMT

Sorry, I don't understand and I don't find the arrow next to the column name

Re: Make a condition on a cell value in a simple table

Tanish — Wed, 19 Jul 2023 07:49:23 GMT

Hi Frédéricdh,

Attaching some screenshot which will help you understand, how we can write condition.

1. Select the column where you want to put the condition.

2. Once you click you will see some options like this.

3. If you need write a condition where your specific column background color will get change then use Background color expression otherwise for changing Text color you can use Text color expression.

You can write a expression like

If (Sum(Sales) > 10000 , Green() , Red() )

Hope this will help 🙂!

Re: Make a condition on a cell value in a simple table

Frédéricdh — Wed, 19 Jul 2023 12:31:35 GMT

Oh I understand, i think u use Qliksense.

Thank you for the screenshot but I don't have qiksense.

And the problem is not the column but the line, i want to color the line with a condition