How to merger two or more district boundaries of India into One Cluster using QS

[Anonymous]

HI Guru's,

I am struggling in creating custom clustering of India district boundaries as per my requirement. It seems there is no straight forward way to achieve the same in QS.

For Ex.

District Name	Cluster name
Faridabad	Delhi
Gurgaon	Delhi
Panipat	Delhi
Rewari	Delhi
Sonipat	Delhi
Agra	Agra
Aligarh	Agra
Hathras	Agra
Mathura	Agra

Please help me, how can I achieve the same in QS.

[Channa]

in the color expression use same color for 2,3 districts no other option

[Qlik_Sense_Hub]

Hi Channa,

In the above example, How can I have one legend name on the map for the whole 'Cluster ' ?

When I enable legends, it is showing legend text in each of the district.

Thank you,

[dwforest]

Add a table with this grouping (from Excel or INLINE if not in a database) to the app and use Cluster Name instead of District Name on your graph

[Qlik_Sense_Hub]

Hi Dwforest,

Thank you very much for your quick response.  I am doing the same thing. But the Cluster name gets repeated in each County/District, as seen in the screenshots. How can I ensure, that Label shows only once per cluster.

Screenshot

Thank you,