All in the Filter

[manoranjan_d]

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

LA

NA

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?.

[fannybenand · Accepted solution]

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. 

[manoranjan_d]

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