topic Re: Showing zero/negative values in bubble chart in Qlikview maps. in QlikView

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

Anonymous — Wed, 05 Jun 2013 07:01:44 GMT

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

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

Gysbert_Wassenaar — Wed, 05 Jun 2013 11:39:23 GMT

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())