Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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.

Tags (2)
4 Replies
Not applicable

Re: Popup / trigger upon clicking a cell in a Pivot Table

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

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

Not applicable

Re: Popup / trigger upon clicking a cell in a Pivot Table

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

Re: Popup / trigger upon clicking a cell in a Pivot Table

Hello Nihar,

Please find the doc attached.

Hope it helps.

konstantin_hill
New Contributor III

Re: Popup / trigger upon clicking a cell in a Pivot Table

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?