topic Re: Stright table with colour records in QlikView

Stright table with colour records

Thu, 06 Mar 2014 14:14:59 GMT

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..

Re: Stright table with colour records

jonathandienst — Thu, 06 Mar 2014 14:24:24 GMT

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

Re: Stright table with colour records

MK_QSL — Thu, 06 Mar 2014 14:26:55 GMT

Like This?

Re: Stright table with colour records

alexandros17 — Thu, 06 Mar 2014 14:26:55 GMT

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

)

Re: Stright table with colour records

sudeepkm — Thu, 06 Mar 2014 14:33:54 GMT

Please find the attached.

Re: Stright table with colour records

Siva_Sankar — Thu, 06 Mar 2014 14:38:57 GMT

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

Re: Stright table with colour records

lawrenceiow — Thu, 06 Mar 2014 14:46:00 GMT

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

Re: Stright table with colour records

Fri, 07 Mar 2014 10:16:15 GMT

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

Re: Stright table with colour records

lawrenceiow — Fri, 07 Mar 2014 10:28:01 GMT

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

Re: Stright table with colour records

ashwanin — Fri, 07 Mar 2014 10:44:23 GMT

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.