Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Popup / trigger upon clicking a cell in a Pivot Table

Hi Community!

I have a pivot table with 2 dimensions and many expressions.

Now, upon clicking a cell in the table, I would like it to show a chart. For example, in the attached file, if I click on '628.3333' (second row third column), I would like to redirect the user/trigger a chart in some other location of the Qlikview document.

How can I do this?

Thanks,

Nihar.

4 Replies
Not applicable
Author

=subfield(GetCurrentSelection(),':',-1)

by the use of this syntax you can get current data anywhere.

Not applicable
Author

Hi Vishwaranjan,

Thanks for the reply!

I have a pivot table and some charts. There is no text object anywhere.

I would like a chart to be displayed upon clicking on the pivot table.

Thanks,

Nihar

Not applicable
Author

Hello Nihar,

Please find the doc attached.

Hope it helps.

konHi
Partner - Contributor III
Partner - Contributor III

Hi,

I have a similar problem. I would like to have an action / trigger "click ond Cell". your solution is working if you don't have an aggregation. If you have a sum and multi lines for "China" and you click the sum value, nothing happens. Any other suggestions?