Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=subfield(GetCurrentSelection(),':',-1)
by the use of this syntax you can get current data anywhere.
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
Hello Nihar,
Please find the doc attached.
Hope it helps.
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?