topic Re: Colur coding in Straight table in QlikView

Colur coding in Straight table

Fri, 27 Mar 2015 12:00:11 GMT

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

Anonymous — Fri, 27 Mar 2015 12:05:16 GMT

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 — Fri, 27 Mar 2015 12:33:59 GMT

or in text color

Fri, 27 Mar 2015 12:46:10 GMT

Thankyou but i need it this way

Anonymous — Fri, 27 Mar 2015 12:48:16 GMT

One cell - one color, sorry.

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

JonnyPoole — Fri, 27 Mar 2015 12:51:21 GMT

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

rajkumarb — Fri, 27 Mar 2015 12:53:28 GMT

Hi Vamsi

Hope this example helps

anbu1984 — Fri, 27 Mar 2015 13:09:36 GMT

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