Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: Filter based on the result of expression

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

Community Browser