Showing zero/negative values in bubble chart in Qlikview maps.

[Anonymous]

Hi all,

I have a scenario as below:

I have created a Scatter chart / Bubble chart and shown it on a Map. (Bing Data)

The expression that I am using to show the size of a Bubble is having a value zero for certain dimensions.

As a result on the Map those points are not shown. Is there a way to show them

Moresoever I also have values that are negative. Can that be shown in any way on the Map?

Thanks for helping out.

Saurabh Pandit

[Gysbert_Wassenaar · Accepted solution]

Of course not. Negative areas are not possible outside exotic branches of maths and physics. You can try using the fabs() function to create absolute values. If necessary use the Background Color option for the expression to give the bubbles with originally negative values a different color from the rest.

Expression: fabs( myexpression )

Background color: if( myexpression < 0, red(), blue())