topic Re: Color in staright Table field = scatter chart field. in QlikView

Color in staright Table field = scatter chart field.

kishorj1982 — Tue, 01 Dec 2015 01:06:47 GMT

Can someone look in the attached and let me know how we can get the same background color for 'Name' field in the staright table same as that of 'Name' field bubble in scatter chart when persistent colors option in the scatter chart is ON.

Please let me know.

Re: Color in staright Table field = scatter chart field.

kishorj1982 — Wed, 02 Dec 2015 03:30:52 GMT

can someone please respond?

Re: Color in staright Table field = scatter chart field.

settu_periasamy — Wed, 02 Dec 2015 04:11:38 GMT

Hi Kishore,

Like this you need?

Just i used in the background color expression like -> Color(RowNo())

But it will change based on your selection. May you can create the RecNo() Field in your Script and put it in your color expression. Like => Color(RecNoKey)

Re: Color in staright Table field = scatter chart field.

settu_periasamy — Wed, 02 Dec 2015 05:39:32 GMT

Hi,

Find attached the Updated version.

Re: Color in staright Table field = scatter chart field.

Gysbert_Wassenaar — Wed, 02 Dec 2015 05:44:03 GMT

Perhaps this blog helps you: Colors in charts‌.

Re: Color in staright Table field = scatter chart field.

Kushal_Chawda — Wed, 02 Dec 2015 06:18:56 GMT

The best way to do it is define the RGB Values for each item like below. Create separate spreadsheet for this

Item R G B

Item1 120 120 120

Item2 150 111 60

like for all item

Now link this spreadsheet to your actual data with Item as key

Now In Chart either in dimension or expression

just use below expression in Background color

=RGB (R,G,B)

Re: Color in staright Table field = scatter chart field.

kishorj1982 — Thu, 03 Dec 2015 01:41:23 GMT

Thanks all for your suggestion. I can create seperate table with RGB values and join with the key. But thing is that my output changes with respect to user selections and I need to have consistency between the scatter chart and straight table.

Now suppose I have 18 colors each are keyed with respect to RGB values with the Fact table data. If I am getting only 5,6.9 value, respective RGB colors will be populated in the straight table. But what about the scatter chart ?

can we control colors of the scatter chart by using expression?

Re: Color in staright Table field = scatter chart field.

kishorj1982 — Thu, 03 Dec 2015 01:47:18 GMT

OK I got it. We can control colors in scatter chart by setting expression on Background color option of the First Expression.

Thanks all for your help