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: 
cevapo_st
Contributor
Contributor

Show values which exceed specific limit

Hey guys, i need your help for the following topic:

I have a table with these 3 columns and approx. 200 rows:

 Qlik1.PNG

 

Now i only want to display the ARE which Balance is over the given limit. Is it even possible in a table chart?

 

Thanks!

Labels (2)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi Cevapo,

What you can do is:

IF(Limit = 'no Limit', null(), Limit)

Enter this as the dimension and don't show the dimension when the value is null().

Jordy
Climber

Work smarter, not harder