Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have looked everywhere and can't find a solution to this.
I will have (hopefully) a bunch of charts pies,bars, etc and each one will need to have hyperlinks on the bars and pie segments.
I've tried playing with actions. I found a few worrying statements that are leading me to think that it's not possible on charts but surely it must be as I have been able to do this on virtually any other charting/dashboard technology I've used before.
Thanks for your help!
I don't think that's possible with qlikview...as you said, it's possible to add action to any object, which means that you only have actions for the whole chart. Maybe some more experienced user can share more knowledge on this.
Hi Kevin
You can also add actions to Selections in certain fields. You could add an action to the field that is the dimension that is in the chart; when a user clicks on the dimension then it will be selected and the action will follow.
The setting is in Document Properties -> Triggers -> Field event triggers
Choose the add actions button under the "on select" category and add the hyperlink there.
If you don't want to apply to your field in other charts, or when a selection is made in a list box, you can copy the column in the script with the same data, but with a different field name and use that.
Erica
='Click here<url>http://www.google.com?RegionNr=' & RegionNr & ''
This is how you can have a link, but it will no be easy to have it in the bar chart unless you specify the dimensions in this way...
But not to a bar on a chart, correct?
No, but as the bars are a dimension and a field, you can set the action on selection in the field. Therefore, you can set an action that is conditional on the item that you are selecting.
EG field = products
Apples, Bananas, Oranges
Set an action on products, the hyperlink expression would be:
pick(match(products,'Apples', 'Bananas', 'Oranges'),
'http:\\Apples','http:\\Bananas','http:\\Oranges')
when the apples bar is selected, a subsequent selection is made in products, which triggers the action. As the only value is apples, the right http is returned
Erica
Ok thanks so much for your help, I will try that.
I also have a stacked bar to do, how would I differentiate the series clicked?
Thanks, but where are you placing that?
No problem Kevin.
When you click on a bar in a stacked chart, the field selected in is the first dimension (ie x - axis). I assume that that is the one that you want to activate the hyperlink? Then you don't need to do anything else ![]()
Erica