Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

conditional color code

i am using RowNo()  as expression in table to show number of rows into the table.

I want to highlight the expression Lable of RowNo()  that is 'Rows' in yellow color when total is more than 150.

2 Replies
hirishv7
Not applicable

Re: conditional color code

Hi,

Check like this,

Right click on chart -> Custom format cell -> and at background color your condition->

Column header Color Change in table-237949.PNG

HTH,

Hirish

“Aspire to Inspire before we Expire!”
Frank_Hartmann
Not applicable

Re: conditional color code

Hi,

use "Custom format cell" and then  edit "Background Color" by following calculated expression:

if(num(RowNo(),'###')>150,yellow(),)

hope this helps