Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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 (4)
1 Reply
Highlighted
Partner
Partner

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