Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
mhapanka
Creator
Creator

Changing color of each stack for measure in which set analysis was used

Hi all,

I have a stacked Bar Chart for my data across regions like this

2.PNG

I want to be able to change the color of the 'data inadequacies' stack to Red and ' No data inadequacies' stack to green.

I have made the data inaedquacies measure using the formula -

Count({$<[District missing] = {"District missing)"}>

+ <[PostalCode missing]={'PostalCode missing'}>

+ <[State missing]={'State missing'}>

+ <[Country missing]={'Country missing'}>

+ <[MapPoint missing]={'MapPoint missing'}>

}Region)

in Fx function under measure

and similarly for data adequacies as well.

How do I change the color of each stack then?

pick(match(Region,'Data Inadequacies','No data inadequacies'),red(),Green()) didnt work it just turned grey

Any help is appreciated!

4 Replies
sunny_talwar

Try this

Pick(Match(Only({1} Region),'Data Inadequacies','No data inadequacies'), Red(), Green())

mhapanka
Creator
Creator
Author

Thanks Sunny

but it still remains Grey

s_achraphe
Contributor III
Contributor III

Hello Malika

Please try this : https://community.qlik.com/thread/309496?sr=inbox

A.

mhapanka
Creator
Creator
Author

Thank you! This helped!