Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ZoeM
Contributor III

Conditional Formatting Total Row in Straight Table

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

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Conditional Formatting Total Row in Straight Table

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))))

View solution in original post

3 Replies
Chanty4u
Esteemed Contributor III

Re: Conditional Formatting Total Row in Straight Table

instead of RGb use  standard colurs and see

red() ,green()

vishsaggi
Esteemed Contributor III

Re: Conditional Formatting Total Row in Straight Table

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))))

View solution in original post

ZoeM
Contributor III

Re: Conditional Formatting Total Row in Straight Table

Thanks Vishwarath, that worked like a charm