How to handle does not starts with and does not ends with

Question & Answer
, ,
1

Hi Team,

Will be planning to move from tableau to quicksight and in tableau we have does not starts with and does not ends with fitlers at visual level how to implement same in qucisight. Also the other filter like starts with or other string function it is case insensitive but on other hand applied filter on quicksight is case sensitive that is causing data issue.

Quick help is really appreciated.

Thanks,
Anshul…

2

Hi @anshul1243,
While QuickSight does not have the same available functions, there is a work around you could try to utilize for your scenario. You could wrap a ‘startsWith’ function inside an ifelse statement to assign a value that you can use to filter out. It might look something like this:

ifelse(startsWith({your_field}, 'YourPrefix') = 0, 1, 0)

So you can put in the string that you’d like to remove in the ‘YourPrefix’ portion, then you can setup a filter to exclude ‘0’.

Additionally, for your note about case sensitive, refer to the link above as there is a way to account for this within the formula you create.

Let us know if you have any additional questions or if this works for your case.

3

@Brett , Thanks for your response, what if I want to use this filter as filter control, then adding calculated column will not work correctly.

4

Hi @anshul1243,
Apologies, I missed the filter portion. Disregard the calculated field; to setup a text box that can be used as a filter in this capacity, you would need to utilize a parameter. I setup an example in the QuickSight Arena view which you can view below. In the example, I setup a ‘does not contain’ filter for my Country field.
Start by setting up a parameter for the field that you’d like to limit based on contains/does not contain. Leave the ‘static default value’ blank.
Next, setup a control for this parameter. You’ll be prompted to do this as soon as you create the parameter. Make sure to setup as a ‘Text Box’.
Then, on your visual, setup a filter for your field (that will be limiting results). My example looked like the following:

image
image230×596 20.3 KB

With this, now whatever I type in to the parameter will be removed from the visual.

Full Arena view:
How to handle does not starts with and does not ends with

Let me know if this works for your case or if you have any additional questions

5

Hi @anshul1243,
Following up here as it’s been awhile since we last heard from you. Did my last post help with your solution or did you have any additional questions?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @anshul1243,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!