Hi Team, How can I select relevant options for a filter based on a calculated field. [QS_FilterRelevantValues] Suppose I’ve created a calculated field basis the field which categorizes it into Letters and Numbers. How do I filter Field based on the chosen Calculated Field? I do not see the calcul…

Hi @Tanisha_Shetty , Thanks for posting your query in the Quick Sight community platform. Coming to your problem I am facing the same issues when I am trying to use the calculated field as filter and use as relevant value but it has no options for the cascading filter. **So for that you need to c…

Are you talking about the relevant values? [image] Relevant values based on filter Question & Answer It would be great if we could show relevant values based on any filter without the requirement for the filter to be in a control. Currently we can only show relevant value…

[image] Tanisha_Shetty: ed a calculated field basis the field which Hi Max, Either options did not help. Maybe my example was not clear enough. Re-wording and sharing my specific use case. I have a calculated field, called Category that categorises groups of countries. This calculated fiel…

Hi Biswajit, Thank you so much! Creating the calculated field in the Dataset helped as Show relevant value option is not available for Calculated fields. Thanks, Tanisha

Hi @Tanisha_Shetty , Have you replicate it at your end? Is it working for you correctly or you are facing any challenges? Thanks & Regards Biswajit Dash

Hi Biswajit, I’ve replicated it and confirm it is working as required. Thanks, Tanisha

[image] Biswajit_1993: ou can show the show relevant options available for the f Hey! I have just encountered this same challenge, would it be possible to request having only relevant values for calculated fields used in controls in an analysis as well? Sometimes because of the size of the D…

Thanks for this update that it is working as required @Tanisha_Shetty ! Very helpful to our peers on the Community. :slight_smile:

Hi @joana , You are highlighted good things but currently it is not possible in Quick Sight. Whether your data set is in Direct Query mode or SPICE mode. Thanks & Regards Biswajit Dash

Filter relevant values based on a calculated field

Q&A

Max April 5, 2023, 7:58pm 2

Are you talking about the relevant values?

Or are you talking about parameters?

Topic		Replies	Views
分析側計算フィールドの関連する値の設定について日本語で質問 \| Q&A filters , feature-request , Business-Intelligence-Engineer , Japanese	2	274	May 1, 2024
How can I hide a value in filter if I need to use this value in a calculated field? Q&A formulas , filters , quick-sight , visuals , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer , qls-filters-controls	2	109	July 13, 2024
Filter which only shows relevant values Q&A filters , quick-sight , calculations	1	2925	November 16, 2022
Can we used cascading filter on Calculated Field Q&A quick-sight	3	418	March 5, 2023
Limitation of calculated field Q&A developer , quick-sight , qls-community	4	60	February 14, 2025

Filter relevant values based on a calculated field

Related topics