Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

All in the Filter

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

1 Solution

Accepted Solutions
fannybenand
Partner
Partner

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. 

View solution in original post

2 Replies
fannybenand
Partner
Partner

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. 

View solution in original post

manoranjan_d
Specialist
Specialist
Author

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