topic Dynamic measures in bubble chart in QlikView

Dynamic measures in bubble chart

Fri, 04 Jul 2014 11:34:19 GMT

I am trying to create a bubble chart where all three measures are dynamic and can be selected from a drop-down menu.

The measures will have a number or different functions depending on the one chosen i.e. average, sum or count. I have tried a number of different things all of which are either very temperamental or fail completely.

Any ideas how to tackle this?

Thanks

Re: Dynamic measures in bubble chart

maxgro — Fri, 04 Jul 2014 12:01:39 GMT

try the link in the attachment

Re: Dynamic measures in bubble chart

Fri, 04 Jul 2014 13:08:04 GMT

Thanks for this Massimo, that's exactly what I want from my graph.

However, I can't seem to replicate what's been done here. As far as I can see they have:

- Loaded in line the list of measures the user can choose from

- Set variables to equal each of these

- Set the expression in the graph to be: Sum($(VariableName))

If I have missed something please let me know. If not, could you suggest why this might not be working for me?