Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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
Partner
Partner

Re: Colur coding in Straight table

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)

MVP
MVP

Re: Colur coding in Straight table

or in text color

1.png

Not applicable

Re: Colur coding in Straight table

Thankyou but i need it  this way

mov
Esteemed Contributor III

Re: Colur coding in Straight table

One cell - one color, sorry.

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

Employee
Employee

Re: Colur coding in Straight table

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

Capture2.PNG

rajkumarb
Contributor II

Re: Colur coding in Straight table

Hi Vamsi

Hope this example helps

anbu1984
Honored Contributor III

Re: Colur coding in Straight table

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