Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakkrish
Creator
Creator

Straight table background color

Hi All ,

 

I am using 2 dimensions and 3 expressions in straight table . My requirement is to change the back ground color based on condition . Can anyone help me to done this .

Dim: Month, Timestamp

Score : 

=if(score<=2.5,red(),
if(score>=3.5,green(),Yellow()))

percentage:

=if(percentage<='80%',red(),

if(percentage>='95%',green(),yellow()))

 

Regards,

Deep.

 

Labels (2)
1 Solution

Accepted Solutions
deepakkrish
Creator
Creator
Author

The expression and condition is correct .

back ground color transparency should be 0% . It working now.

 

Thanks,

Deep.

 

 

View solution in original post

3 Replies
Lisa_P
Employee
Employee

If score and percentage are fields, you need to aggregate - sum(score) ..

If they are column names in the table, it should work out ok.

deepakkrish
Creator
Creator
Author

That is not a filed name just a calculation..

deepakkrish
Creator
Creator
Author

The expression and condition is correct .

back ground color transparency should be 0% . It working now.

 

Thanks,

Deep.

 

 

View solution in original post