Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hyperlinking a bar chart

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!

8 Replies
andrefpc
Partner - Creator II
Partner - Creator II

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.

Not applicable
Author

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

giakoum
Partner - Master II
Partner - Master II

='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...

Not applicable
Author

But not to a bar on a chart, correct?

Not applicable
Author

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

Not applicable
Author

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?

Not applicable
Author

Thanks, but where are you placing that?

Not applicable
Author

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