Discussion Board for collaboration related to QlikView App Development.
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.
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)
or in text color
Thankyou but i need it this way
One cell - one color, sorry.
Unless there is an extension for this, that is unlikely.
Disable vertical expression cell borders ? and use 3 expressions (measure 1 , '/', and measure 2)
Hope this example helps
Create another table and remove caption and place it on original table