Drop Down filter not populating values in Qliksense

[Aspiring_Developer]

Hello ,

I have a drop down filter created using variable input in Qliksense:-

Variable -vFootprintDropDown 

Values (Set as Dynamic)- ='CITY_TOWN_NAME~City|TOP_POPULATED_CITIES~Top Populated Cities|REGION_NAME~Region|COUNTRY~Country|GRT_LONDON~Great London|MP_CONSTITUENCY_NAME~MP Constituency Name|COUNTY~County|HDL_Flag~HDL_Flag'

This filter toggles the chart :-

Table Dimensions -=$(vFootprintDropDown)

Label name of the dimension-

=Pick(WildMatch('$(vFootprintDropDown)','CITY_TOWN_NAME','TOP_POPULATED_CITIES','REGION_NAME', 'COUNTRY','GRT_LONDON','MP_CONSTITUENCY_NAME','COUNTY','HDL_Flag'),

'City', 'Top Populated Cities','Region','Country','Great London', 'MP Constituency Name','County','HDL_Flag')

Measure -Sum(TAKE_UP)

The table is working fine with all the filters except one which is HDL_FLAG:-

Note:- I have not suppresses null or zero values in any of the dimension or from add ons

When I am selecting HDL_FLAG from the drop down , it is not showing the correct breakdown.

In order to troubleshoot , I created a seperate table with dimension as HDL_FLAG and data is populated :-

But when I am trying to populate the data using drop down as HDL_Flag ,it is not working and only populating .

Can anyone please help me in this ?

@Kushal_Chawda  @tresesco 

Thanks

[Kushal_Chawda · Accepted solution]

@Aspiring_Developer  It seems it's column name issue. Your HDL Flag column name seems to have space instead '_' which is [HDL Flag] as I can see in your separate table with HDL Flag. Check if this is the case

[Aspiring_Developer]

Hi @Kushal_Chawda  the original field name in the back is HDL_Flag

I checked it even my replacing HDL_Flag with HDL Flag in pick match condition but it didn't worked. I have used HDL_Flag but still giving me null