topic Re: conditional color code in QlikView

conditional color code

Thu, 27 Oct 2016 19:45:02 GMT

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.

HirisH_V7 — Thu, 27 Oct 2016 19:59:27 GMT

Hi,

Check like this,

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

HTH,

Hirish

Frank_Hartmann — Thu, 27 Oct 2016 20:25:58 GMT

Hi,

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

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

hope this helps