Stright table with colour records

[#1]

I have a straight table in Qlikview.

ID   group

1     10

2     10

3     10

4     20

5     30

6     30

7     30

8     30

All the 10 related records, I want to Display in Green.

All the 20 related records, I want to Display in Blue.

All the 30 related records, I want to Display in Red.

How can I achieve this ? please help..

[jonathandienst]

Hi

Click the + next to the expression in Properties | Expressions, and enter this expression in Text Color:

=If([group] = 10, Green(), If([group] = 20, Blue(), If([group] = 30, Red())))

HTH

Jonathan

[MK_QSL]

Like This?

[alexandros17]

In your dimension click on group and in backgroud color write:

If(group=10, rgb(0,255,0),

If(group=20, rgb(0,0,255),

If(group=30, rgb(255,0,0),

rgb(0,0,0

)

)

)

[sudeepkm]

Please find the attached.

[Siva_Sankar]

Hi,

Find the attached document, all you have to do is, in the expression and dimension tab, clikc the + sign and click the background coloru and paste the following expression.

Pick(match(sum(group),10,20,30),rgb(0,255,0), rgb(0,0,255),rgb(255,0,0))

Regards.

Siva

[lawrenceiow]

How about this approach:

In your script:

ColourMatch:

LOAD * Inline [
Group,   R,  G,    B
   10,   0, 255,   0
   20,   0,   0, 255
   30, 255,   0,   0
];

Then in your Chart properties use the expression RGB(R,G,B) on Background Color or Text Color

This will then look like this...

Repeat this if you want the other columns coloured too.

Regards

[#8]

Hi,

lawrenceiowanswer works fine in QV 11.20 SR3. But when I try to do the same in SR5 the "Background Color" property doesn't have any effect. The background color keeps white regardles. If this a known issue?

Thank you,

/Yolanda

[lawrenceiow]

Good question Yolanda Perdomo, I am using QV 11.00 SR1 so don't know about SR5, sorry.

[ashwanin]

If you just want to display the value in straight table with colours then you can do it in straight table properties.

Properties -->>Visual Clues--> Select Group ( in snap shot its Positive) -->Now select the limit ie 10, 20 ,30 and choose colours as you required.