graph color on the basis of dimension value

[swiftfahad]

I have straight table  (plz refer image attached) for sample

I need stack bar chart where values are distributed on single bar of KU1

problem is that I want to show same color for all empty portion on the graph so i can realize user the empty slots on the bar........ right now its showing  different color for each customer see attached sample. 

is this possible?

[vchuprina · Accepted solution]

Hi,

In Qlikview, you can change the color in the background color of your expression

And use following expression 

Pick(Match(CUSTOMER_NAME, '*empty*'), Green())

In QlikSense select Colors and legend in the Appearance menu. Then select a custom color and determine it by expression, for your example I use the following expression

Pick(WildMatch(CUSTOMER_NAME, '*empty*', 'xyz', 'efg', 'abc'), Green(), RGB(229,182,148),RGB(255,217,47),RGB(252,115,98))

Where each value has its own color

Result

Regards,

Vitalii

[swiftfahad]

thank you its working also look into this post

https://community.qlik.com/t5/App-Development/DATA-SORTING-ON-GRAPH/m-p/1918818#M75554