How to filter based on the selected value of the Multiple List Box?
Currently, i have 2 list box and i called it as 1stListBoxCountry & 2ndListBoxCountry to display all the available value of the World Country. i want filter and display the result based on the 1stListBoxCountryand 2ndListBoxCountry as below scenario. May i know how to filter the selected value of the 2 list box above by writing the expression with OR condition?
Example :
ID
User
1st Preferred Country
2nd Preferred Country
1
Alex
Malaysia
Singapore
2
Billy
Thailand
Indonesia
Scenario 1,
If user select 1st Preferred Country "Malaysia" OR 2nd Preferred Country = "Indonesia", the report will showing 2 records.
Scenario 2,
If user select 1st Preferred Country "Malaysia" OR 2nd Preferred Country = "Singapore", the report will showing 1 records.
maybe a simple straight_table_chart would do this?
- If you select both your listbox_values (1st_preferred_country and 2nd_preferred_country) as dimensions and the records as expressions, then you can select on both fields => it will automatically be an AND selection - as soon as you select on the 1st listbox_value, you will only be given the option to choose between those values (from the 2nd listbox) which are compatible
=> The same effect that you get when you add two listboxes - you select in one, and a part of the values in the second one turns grey (non-compatible)
=> I think there is a blog around here by Henric Cronstroem about how to implement the OR_logic (or v.v.?) => Sorry, I don't remember too clearly anymore.
