Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aniket_2701
Contributor
Contributor

Color change by dimension

Hii All,

I have question about change color as per dimension.

Ex: Prod,Sales

for 1 :Red

2 : Green

18 Replies
aniket_2701
Contributor
Contributor
Author

I am not getting.

For prod A = Red

For Prod B = Yellow

etc

i hope i clear

prma7799
Master III
Master III

Like this ?

color.png

Kushal_Chawda

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)



aniket_2701
Contributor
Contributor
Author

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

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Master III
Master III

Please let us know 10 dimension with expected colors.

aniket_2701
Contributor
Contributor
Author

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

aniket_2701
Contributor
Contributor
Author

Take any 10 diff color for dimension.

Frank_Hartmann
Master II
Master II

maybe like this?

Aufnahme_2017_06_29_09_20_00_649.gif