Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
mazman
Contributor
Contributor

Greater Than for the results of an expression

I have an Straight Table expression where I get the average for MEM:
Label: MEMAvg
Expression=num(sum(MEM)/Days
/100,'####,###0.00%')
Returns= 84.68%(example)

I need to then only show only those MEMAvg that is greater than 80%.

I cannot figure out the proper way

Dan

Labels (1)
3 Replies
jwjackso
Specialist II
Specialist II

Can you use the "Dimension Limits" tab to show only values that are greater than 80%?

mazman
Contributor
Contributor
Author

It is not a Dimension, so it doesn't appear as an option under the Dimensions Limits tab

Brett_Bleess
Support (Former)
Support (Former)

Take a look at the following Design Blog post, I think that may be for what you are looking to solve this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.