Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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.