Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mbanerjee95
Contributor II
Contributor II

How to drop columns that are not null?

Hello all,

I am currently working on a visualization and my concern are the columns that are not null but have very small data values as opposed to the largest three bars in the bar graph. These other countries appear in other sheets (country is a PK). I am unsure about how to create a minimum or eliminate them all together (I already unchecked include null values). Thanks again in advance, I appreciate it!

Sincerely,

Munna

capture10.PNG

2 Replies
mov
Employee
Employee

You can use Limitation - fixed number for the Country dimension,and set it to top 3.

rittermd
Master
Master

Setting a limitation is one approach if you just want to see the Top n.

You could also use an expression in your dimension to limit what is displayed based on a value from your calculation.

Something like

If (Sum(Field) > 100, Field, 0)