Associative coloring issue

[Qlik1_User1]

Need to show only White /possible values

Requirement :

1. Field “Country” no multi select allowed.

2. Show only white values (related/ active values)  of related dimensions like City, State, Company and multi selection is mandatory

 Solution:

1.       I have used “Always one selected value”.

2.       Below are the expression used
For State - AGGR(ONLY({1<Country=P(Country)>}State),State)
for City - AGGR(ONLY({1<Country=P(Country)>}City),City)
for Company - AGGR(ONLY({1<Country=P(Country)>}Company),Company

 Issue: Qlik associated coloring (Light Grey , Dark grey) is not working properly for State, City and Company Filter pane,

When selecting some values in filter pane the associated values got “Dark grey color” (excluded value) however it should be in light grey (Alternative Value).

Below is sample data

Country	State	City	Company	Sales
India	Del	D	A	10
India	H	G	S	20
India	U	N	D	30
India	K	HR	Q	40
USA	Cali	Cal	X	50
USA	LV	Las	V	60
Canada	Z	Can1	QA	70
Canada	Z	Can1	X12	1
Canada	Z	Can2	QW	80
Canada	Z	Can3	WE	90
Canada	Z	Can4	SD	100
Canada	Z	Can5	DF	110
Canada	Z	Can6	CV	120
Canada	Z	Can7	AX	130
Canada	Z	Can8	CVB	140
Canada	Z	Can9	DF	150
Canada	Z	Can10	DF	160

[Qlik1_User1]

Hi All,

Kindly suggest some solution for this.