Map - Point Layer - displaying all points - do not display zero/null points

[jerryr125]

Hi - 

I am probably overlooking a setting but I have a question about the point layer.

Is there a way NOT to display points with zero/null value ? That is, Size/Shape for each location is determined by a quantity.

Some of the points on the map do not have a quantity and therefore I do not wish for those points to display.

Thoughts ? Jerry

[Steven_Haught]

@jerryr125 

You can do an IF statement in the dimension if you have a calculated value already. Ex. IF(Sales>0, Store). This would only show stores that have sales. If you don't have a calculated value you will likely want to create a flag in the load.

[Steven_Haught · Accepted solution]

@jerryr125 

Or of you do not want to create a flag you could try this:

=IF(
Aggr(
Sum({$<Setexpression{}>}SALES)
,Store)
>0
,Store)

The 0 can be set to any value you want.

You can make this dynamic by using a variable and a variable input box. Set the zero to a variable as such:  '$(vSalesAmount)'

Where vSalesAmount is blank. Use variable input box to place your target amount in. 

[jerryr125]

Thank you very much !