Filtering by exact values

Q&A
, ,
1

Hello.
Please specify are there any simple solution to filter field by exact values?
For example.

Filed name Numbers
Values 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

I need only 4/7/10. How can I do it?

image

Thank you

2

Hi @weird_guy

Welcome to the community!

Can you try using the filter type Filter list for multi-selection, or Custom filter list to manually enter the numbers you want to filter.

image

Please refer the below documentation this might be helpful for you.

3

Hello @Xclipse
Thank you for your help.

Next question here.

For example I have

Filed name Numbers
Values 12, 2222, 333343, 434334, 5343, 6, 7, 8, 9, 10, 45454,545454,43433422

I need all values that starts from 4. How can I do it? Your solution doesn’t work here.

4

Hi @weird_guy

You can create a calculated field as shown below and then apply a filter to the calculated field.

Example :

ifelse(startsWith(toString({Numbers}), "1"),1,
    ifelse(startsWith(toString({Numbers}), "2"),2,
        ifelse(startsWith(toString({Numbers}), "3"),3,
            ifelse(startsWith(toString({Numbers}), "4"),4,
                ifelse(startsWith(toString({Numbers}), "5"),5,
                    ifelse(startsWith(toString({Numbers}), "6"),6,
                        ifelse(startsWith(toString({Numbers}), "7"),7,
                            ifelse(startsWith(toString({Numbers}), "8"),8,
                                    ifelse(startsWith(toString({Numbers}), "9"),9
                                        ,0
                                )
                            )
                        )
                    )
                )
            )
        )
    )
)