topic Re: Color change by dimension in QlikView

Color change by dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hii All,

I have question about change color as per dimension.

Ex: Prod,Sales

for 1 :Red

2 : Green

Re: Color change by dimension

Sergey_Shuklin — Thu, 29 Jun 2017 06:10:13 GMT

Hello!

Maybe this will help:

How to change Dimension background colour in pivote chart

Re: Color change by dimension

prma7799 — Thu, 29 Jun 2017 06:10:34 GMT

Can you please elaborate more?

Re: Color change by dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 06:11:38 GMT

As always, short question won't help you as much you need.

Re: Color change by dimension

Anonymous — Thu, 29 Jun 2017 06:27:27 GMT

How to give color as per dimension

Re: Color change by dimension

prma7799 — Thu, 29 Jun 2017 06:29:17 GMT

Please share some sample app with expected output.

Re: Color change by dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 06:32:38 GMT

When you talk about dimension text color, You have give some thing like below

If(FieldName = 'Smart', Green(), If(FieldName = 'Poor', Red(), LightCyan()))

This condition you must use from Dimension and go to Text colour then paste over there and hit ok. Here, How expression works as If FieldName has Smart value or name then text colour shows as green same as Poor text colour shows as Red or else LightCyan. This should work as you required

HTH

Anil

Re: Color change by dimension

Anonymous — Thu, 29 Jun 2017 06:46:23 GMT

Its shows wrong.

I want to show the each dimension having different color.

Ex:Prod ,Sales

a,100

b,200

c,300

each dimension having different color in bar chart.

Re: Color change by dimension

prma7799 — Thu, 29 Jun 2017 06:50:21 GMT

Like this ?

Re: Color change by dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 06:50:52 GMT

May be one option is go to colour tab and use persistence colour check box

Or else, Try this in BG colour from Expression

Color(FieldIndex('FieldName',FieldName))

Re: Color change by dimension

Anonymous — Thu, 29 Jun 2017 06:55:12 GMT

I am not getting.

For prod A = Red

For Prod B = Yellow

etc

i hope i clear

Re: Color change by dimension

prma7799 — Thu, 29 Jun 2017 06:59:03 GMT

Like this ?

Re: Color change by dimension

Kushal_Chawda — Thu, 29 Jun 2017 06:59:52 GMT

Create one table with dimension value and RGB values

Color:

LOAD * inline [

Prod, Color

A, RGB(10,10,20)

B, RGB(100,10,20)

C,RGB(200,10,30) ];

link the above table with your data

Now go to expression-> background color , put below expression

=only(Color)

Re: Color change by dimension

Anonymous — Thu, 29 Jun 2017 07:00:18 GMT

yes,but i have 10 dimension and each have diff color.

Re: Color change by dimension

Anil_Babu_Samineni — Thu, 29 Jun 2017 07:01:19 GMT

No, Question still not clear, any way

If you want your own colours, I always recommend you to use Colours tab itself. If not, I am not sure where were you at this point

And, Finally i conclude to you, Why can't you share sample data set atleast 5 rows to get in on fly

Re: Color change by dimension

prma7799 — Thu, 29 Jun 2017 07:05:08 GMT

Please let us know 10 dimension with expected colors.

Re: Color change by dimension

Anonymous — Thu, 29 Jun 2017 07:05:40 GMT

I have 10 product each having diff values and i take inline

EX:

Prod , Sales

a 10

b 20

c 30

d 40

Each value dimension with diff color .

not hard coded.

Thanks

Re: Color change by dimension

Anonymous — Thu, 29 Jun 2017 07:06:54 GMT

Take any 10 diff color for dimension.

Re: Color change by dimension

Frank_Hartmann — Thu, 29 Jun 2017 07:20:45 GMT

maybe like this?