topic Re: Scatter chart - bubble drill-down in QlikView

Scatter chart - bubble drill-down

danialier — Wed, 15 Jan 2014 08:33:39 GMT

Hello,

I have a scatter chart with a bunch of bubbles, one per each country. Is there any way to click on a specific bubble and by doing that to move to another sheet where to show further details behind this bubble/country ?

Thanks !

dani

Re: Scatter chart - bubble drill-down

jonathandienst — Wed, 15 Jan 2014 08:40:45 GMT

Dani

Assuming Country is a field, you could add trigger to the OnSelect and OnChange triggers for the field (see Document Properties | Triggers) with an "Activate Sheet" action. The sheet that activates should then be sensitive to the Country selection.

If you want a different tab for each country, then create sheets with the sheetID containing the country, such as SH_France, SH_Germany etc. Then use the expression ='SH_' & Country to select the sheet.

HTH

Jonathan

Re: Scatter chart - bubble drill-down

danialier — Wed, 15 Jan 2014 09:09:50 GMT

great thanks Jonathan