topic Re: Map - Point Layer - displaying all points - do not display zero/null points in App Development

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

jerryr125 — Sat, 16 Nov 2024 01:17:20 GMT

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

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

Steven_Haught — Fri, 16 Oct 2020 13:26:43 GMT

@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.

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

Steven_Haught — Fri, 16 Oct 2020 13:40:47 GMT

@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.

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

jerryr125 — Tue, 20 Oct 2020 15:40:29 GMT

Thank you very much !