topic Re: All in the Filter in App Development

All in the Filter

manoranjan_d — Sat, 16 Nov 2024 19:09:27 GMT

Hi all,

I have requirement for the qliksense Filter example Business Area Filter have EMEA,APAC,EUR,LA,NA

As the user clicks on “Business Area”, of any value, the drill down of country shd appear for the specific region, (Drill down has been achieved for this filter )

Now the user need All in the Business filter

example

Business Area Filter

All

EMEA

APAC

EUR

Now when the user select All, All country shd come in the drill down. how to achieve the All in the filter? and drill down to show all the country?.

Re: All in the Filter

fannybenand — Fri, 07 Feb 2020 11:53:14 GMT

I'm not sure that adding the value "All" in the business area is the right way to solve your problem, it's not really the Qlik logic.

If you need all the Business Area, then you should selected none or all the values.

Then in your case, in order to see all the countries in the same visualization (the one with the business area > country hierarchy dimension), I guess you should better add an alternative dimension for this case instead of using the drop down.

Re: All in the Filter

manoranjan_d — Fri, 07 Feb 2020 14:12:17 GMT

I tried with even match function its not working

Concat( if(match([Business Area],'EUR','LA','APAC and MEA','NA'),'ALL'),',')

i got only ALL value but other values not generating