Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhapanka
New Contributor III

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
MVP
MVP

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

Try this

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

mhapanka
New Contributor III

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

Thanks Sunny

but it still remains Grey

s_achraphe
New Contributor III

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

Hello Malika

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

A.

mhapanka
New Contributor III

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

Thank you! This helped!

Community Browser