Drop Down filter not populating values in Qliksense

Aspiring_Developer — Tue, 22 Oct 2024 14:48:28 GMT

Hello ,

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

Variable -vFootprintDropDown

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 @tresB

Thanks

Re: Drop Down filter not populating values in Qliksense

Kushal_Chawda — Tue, 22 Oct 2024 15:01:16 GMT

@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

Re: Drop Down filter not populating values in Qliksense

Aspiring_Developer — Tue, 22 Oct 2024 15:59:10 GMT

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

topic Re: Drop Down filter not populating values in Qliksense in App Development

Drop Down filter not populating values in Qliksense

Re: Drop Down filter not populating values in Qliksense

Re: Drop Down filter not populating values in Qliksense