Filter using a field from where condition of datasets

Q&A
, ,
1

I have a SQL query in my dataset which filter based on a where condition suppose where condition is applied on fieldA, I am not using that fieldA in my select command i.e the fieldA will not be present in my result set.

Is it feasible to have the fieldA in my filter for the visual even if it is not part of the dataset only the WHERE condition

2

Hello @Tanu_13

You might have to include the field in your select command, Quick Sight will not be able to identify the field as a column in the dataset if it is not present and thus filters will not be applicable.

We can only apply filters on columns/fields present in the dataset.

3

Hi @Tanu_13

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @Tanu_13

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!