Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

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

Contributor
Contributor

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

Digital Support
Digital Support

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.