topic Re: Scatter/Bubble Chart Data Labels in QlikView

Scatter/Bubble Chart Data Labels

Anonymous — Tue, 23 Jul 2013 15:06:48 GMT

I have a buble chart with one dimension and three expressions. I would like the data lable to show the dimension and the bubble size value. I can do this in Excel via VBA by concatenating the two and assigning it to the data label text property, but there doesn't seem to a way to do this using QlikView properties. First, is there a way to do this using the property settings that I'm missing? Second, is there a way to do this in a VB macro?

Re: Scatter/Bubble Chart Data Labels

Gysbert_Wassenaar — Tue, 23 Jul 2013 16:39:59 GMT

You can probably use the dual function for this: dual( DimensionA & ' - ' & bubblesizeexpression, bubblesizeexpression)

Edit: nevermind, just realized that the scatterplot can only show dimension values as labels, not expression values. So you need a calculated dimension. Something like =DimensionA & ' ' & aggr(sum(Something),DimensionA)

Hmm, cyclic group... = $(=getcurrentfield(MyGroup)) & ' ' & aggr(sum(Something),$(=getcurrentfield(MyGroup))

Re: Scatter/Bubble Chart Data Labels

Anonymous — Wed, 24 Jul 2013 02:43:07 GMT

I'm assuming you meant for that to be used as the Dimension on Scatter/Bubble chart. However, I got an error message when using that expression even though the expression builder said it was OK. Furthermore, my Dimension is actually a cyclic group. If you use a simple calculated dimension (=CyclicDimension), the cyclic group does not appear on the chart. Only the first member of the cyclic group appears.