Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having a field with values Seperated by pipeline.
For example
| Sample | Value |
| A|B|C | 1 |
| A|B | 1 |
| A|C | 2 |
| B|C | 3 |
| C|A|B | 1 |
| A|D | 4 |
| A | 1 |
| C|B | 3 |
| B | 4 |
| D | 1 |
I need a multiselect dropdown with the distinct values from the column. In this case my dropdown should contain A, B, C and D.
If I select A from the dropdown then it should select the following rows
| Sample | Value |
| A|B|C | 1 |
| A|B | 1 |
| A|C | 1 |
| C|A|B | 1 |
| A|D | 4 |
| A | 1 |
Now If I select both A and B from the dropdown Then it should select the following rows
| Sample | Value |
| A|B|C | 1 |
| A|B | 1 |
| C|A|B | 1 |
If I select A,B and C , Then I should get
| Sample | Value |
| A|B|C | 1 |
| C|A|B | 1 |
Can somebody help me with this
Please take a look at this topic: Filter widget | Comma separated values and this QS Help article: Searching within selections or visualizations
hth