Need to select top 20 results in a bar chart only if greater than a certain value

[usman7vt]

Can you please tell how I would display top 20 results only above a certain value. In the below example we have sales from different stores for a particular company. Some stores did not make any sales, how can I remove $0 values from the chart but still keep top 20 intact (As for another company we may have stores in which all 20 spots are populated making higher the $0 in sales).

[JHuis]

Does supress zero values dont work?

https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-Sense-suppress-zero-null-values-in-Measure/td-p...

[usman7vt · Accepted solution]

Thanks for pointing me in the right directions, I had to convert zero values to first Null() and then drop them either using the 'Dimension' or 'Data Handling'

if(Sum([Sales]) > 0, Sum([Sales]), Null())