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: 
Not applicable

Colur coding in Straight table

Hi all,

I have an expression in straight table need to color code it

num([My field 1],'#,##.##M') & '  /  ' & num([My field 2],'#,##.##M')

If field 1 Great than 40 M compare to field 2 , Field 1 need to be red. tried different methods but not working.

Thankyou

7 Replies
Anonymous
Not applicable
Author

just write in the Visual Clues tab

if ([My field 1]-[My field 2]>40, rgb(255,0,0))

you might adjust the numbers according to your Format (maybe > 40000000 if it is millions)

maxgro
MVP
MVP

or in text color

1.png

Not applicable
Author

Thankyou but i need it  this way

Anonymous
Not applicable
Author

One cell - one color, sorry.

Unless there is an extension for this, that is unlikely.

JonnyPoole
Employee
Employee

Disable vertical expression cell borders ? and use 3 expressions   (measure 1 , '/', and measure 2)

Capture2.PNG

rajkumarb
Creator II
Creator II

Hi Vamsi

Hope this example helps

anbu1984
Master III
Master III

Create another table and remove caption and place it on original table