How can I select multiple lines from a table? (and how could I then DESELECT those items to exclude them form the analysis?)

Q&A
,
11

Thanks for sharing this, I implemented the solution and added the following options.

  • Sort by length to keep selected values on top, add a calculated field and sort by it.
    strlen({updated_selected_item_ids})

  • On filtering avoid no data when nothing is selected returing -1 to use in filter along with 1 using OR condition.
    added strlen(${selected_item_ids})<=1,-1 to the folowing.

in_selected_item_ids = ifelse(locate(${selected_item_ids},item_id ) > 0 , 1, strlen(${selected_item_ids})<=1,-1, 0)

Note:
Logic needs to be added to make it work with null values.

I think this should be provided by the tool. :frowning_face:

2 Likes
Multiselect table: select all, select all from filtered results, deselect manual, and on-dashboard export options
Multiselect table: select all, select all from filtered results, deselect manual, and on-dashboard export options