Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

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
Champion III
Champion III

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

instead of RGb use  standard colurs and see

red() ,green()

vishsaggi
Champion III
Champion III

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

ZoeM
Specialist
Specialist
Author

Thanks Vishwarath, that worked like a charm