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

Popup / trigger upon clicking a cell in a Pivot Table

Tue, 26 Feb 2013 11:55:00 GMT

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.

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

Tue, 26 Feb 2013 11:59:57 GMT

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

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

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

Tue, 26 Feb 2013 12:04:11 GMT

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

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

Tue, 26 Feb 2013 12:27:04 GMT

Hello Nihar,

Please find the doc attached.

Hope it helps.

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

konHi — Wed, 11 Feb 2015 08:37:58 GMT

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?