filter on shiny

[supermarco]

Hello,

I encountered a minor problem on shiny that i could not solve although it is more an R problem overall.
When i select e.g. a value, shiny returns several results, but when i add to the value a particular year and country, shiny returns less outputs while the opposite should be true because i add inputs. Perhaps my filter structure is failed. Thanks a lot. The code looks like:

mainPanel{
selectizeInput('list1', VALUE', selected = "100", choices = unique(dataset$value), multiple=TRUE),
selectizeInput('list2', 'YEAR, selected = "2025", choices = unique(dataset$year), multiple=TRUE),
selectizeInput('list3', 'COUNTRY', selected = "US", choices = unique(dataset$country), multiple=TRUE),

}

server <- function(input, output, session) {
DATA <- eventReactive(input$update, {
dataset %>%
filter(value == input$list1) %>%
filter(year == input$list2) %>%
filter(country == input$list3) %>%
}, ignoreNULL = FALSE)
}

[FJCC]

I disagree with the idea that you should get more data returned with more filter inputs. As written, the filters require that three conditions be met simultaneously. Only rows with a certain value AND year AND country will be returned. If you just filtered on the value, any year or country would be acceptable and more rows would be returned.
If you want the filter to return data that have the given value OR the given year OR the given country, you have to connect the filter conditions with OR logic.

dataset %>%
filter(value == input$list1 | year == input$list2 | country == input$list3)

[supermarco]

Thank you very much for your clear and interesting response. I miss something and please let me try this OR solution and come back but i believe it is the right solution.