Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter based on the result of expression

Hello dear!

I am looking to apply a filter based on values ​​resulting from the following constant expression in a graph :

Sum ( { < Moment = {' Held '} >} [ Qt . BDA ] ) / Sum ( { < Moment = {' PLANNED '} >} AGGR ( distinct SUM ( DISTINCT [ Qt . BDA ] ) , Chv_Mom_Prod_Mês_Colab ) )

This expression will return percentages for each dimension. I would like to create a filter based on percentage , which , for example, by clicking the green button seep results that were > = 100 % ; clicking yellow values ​​between 80 % and 99 % and clicking the red values ​​below 80 % .

Sorry for my bad english and i thank the help.

1 Reply
MK_QSL
MVP
MVP

Provide sample data... You can create a List Box based on expression which will give you different % slots...