How to use "like" wildcard operator in QS

Question & Answer
,
1

I wanted to exclude the firstname column which has numbers in it. I’m trying to use the custom filter type with the condition ‘does not contain’ and value ‘[0-9]’, but it doesn’t seem to be working. Is there any alternative to using 'firstname NOT LIKE '[0-9]%

2

Hi @Asfak

Currently QuickSight doesnt support regular expression type search filters . You may alternatively try the below workaround .

create calculated field to find all the location of numbers from 0-9

image
image1120×530 48.9 KB

and then apply the filtering on this calculated field to show only with value 0

image
image2534×1122 253 KB

Please create the calculated field in the dataset (SPICE) itself to avoid doing it at run time , if its larger dataset then would recommend to do it at underlying datasource/database itself.

Did this solution work for you? I am marking this as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

Thanks
Vinod