topic Re: Conditional Formatting Total Row in Straight Table in QlikView

Conditional Formatting Total Row in Straight Table

ZoeM — Tue, 24 Jul 2018 17:51:43 GMT

Hi Community,

I am trying to conditionally format the total rows in my straight table based on a the selections made by the user.

I am using the following expression:

If(RowNo()=0 and Item='PEC',If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])>10,RGB(255,0,0),RGB(255,255,255)),

If(RowNo()=0 and Item='PEC',If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])<=10,RGB(0,128,0),RGB(255,255,255))

))

When I only have the format 'Red' (>10), it works fine. But when I add the <10, it does not format anything (blank).

Any ideas on what I may be doing wrong?

Thanks in advance

Re: Conditional Formatting Total Row in Straight Table

Chanty4u — Tue, 24 Jul 2018 17:56:06 GMT

instead of RGb use standard colurs and see

red() ,green()

Re: Conditional Formatting Total Row in Straight Table

vishsaggi — Tue, 24 Jul 2018 18:22:59 GMT

May be try this:

= If(RowNo()=0 and Item='PEC',

If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])>10,RGB(255,0,0),

If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])<=10,RGB(0,128,0),RGB(255,255,255))))

Re: Conditional Formatting Total Row in Straight Table

ZoeM — Tue, 24 Jul 2018 18:38:17 GMT

Thanks Vishwarath, that worked like a charm