Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
zwyne
Creator
Creator

Totals row as an Image in the straight table

Hello  everyone,

PFA,

I would like to display the Total rows as image or icon. Or maybe create another column with icon/image based on this condition :

If(Column(1)<=26,'qmem://<bundled>/BuiltIn/led_g.png',
if(Column(1)>=27 and Column(1)<=55,'qmem://<bundled>/BuiltIn/led_y.png','qmem://<bundled>/BuiltIn/led_r.png'))

 

Regards

2 Replies
vishsaggi
Champion III
Champion III

You might have to change your expression accordingly. 

The way you do it is to add a new column as expression and use your formula in that like below screenshot. 

Capture.PNG

zwyne
Creator
Creator
Author

Hello again ,

When I do what you suggested I get the below result. So what I am expecting to see is green icon next to 21 and the other icons next to the numbers should not be visible.ChartResult.PNG