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

[mhapanka]

Hi all,

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

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!

[sunny_talwar]

Try this

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

[mhapanka]

Thanks Sunny

but it still remains Grey

[s_achraphe]

Hello Malika

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

A.

[mhapanka]

Thank you! This helped!