
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filter across sheets and Pick Function for Choosing a Measure Query
Would you have some time to help me understand 2 issues.
- So in one sheet I would like my filter on a field to be multi-select and in another sheet I would like it to be single select filter, how can I go about doing that?
- Also can I not use Pick(vLanguage, col_english, col_french) in a filter (2 columns have translations) <- this doesn't work but some how Pick(vLanguage, 'col_name_english', 'col_name_french') seems to work.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For that you need to use Pick and Match Functions Together.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For 2nd, It is not working because in Pick(vLanguage, col_english, col_french) col_english,col_french are dimension or variable but when you put them in incerted commas they become values.
Now for 1st no it is not possible to make a field be single selectable on one sheet and multi on another,
but there can be a different solution like:- Let the Field name be D1
In the sheet you want filter to be multi-selectable , let it remain that way as default filter pane are multi-selectable.
Now for second sheet create a variable name vD1 and assign it any random Value from D1 in its definition this will be its default value, after that add variable input and select vD1 , and in its values select Dynamic.
For Dynamic Set the set Expression to be Concat(distinct D1,'|') .
Now in your set expression for this sheet add D1 = {"=$(=vD1)"} , for required expressions.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So what would be the best way to figure out so that in Pick(vLanguage, col_english, col_french) col_english,col_french are remain as a field?
As one column has English translation and the other has French one. Based on Variable Input Filter, I need to choose the appropriate column as the filter column.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For that you need to use Pick and Match Functions Together.
