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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Returning Values Less than a certain %

Good day

Please assist in providing the correct syntax to return values that are less than 100% in the Complete table?

This would be easy if it were just values that weren't in percentage form as I would use an IF statement and <100

I%.PNG

Labels (1)
1 Solution

Accepted Solutions
pooja_prabhu_n
Creator III
Creator III

Hi,

you can restrict using dimension limits

100%.png

View solution in original post

2 Replies
pooja_prabhu_n
Creator III
Creator III

Hi,

you can restrict using dimension limits

100%.png

Anonymous
Not applicable
Author

Thank you! That's perfect