topic Re: Trigger when clicked on a pivot table. in QlikView

Trigger when clicked on a pivot table.

Anonymous — Wed, 25 Oct 2017 09:25:52 GMT

Hi All,

Can we implement the case when the user clicks on any cell in the pivot table, a trigger should be implemented to open a new chart.

I tried using the filter of the field to trigger an action(table gets filtered when clicked on any cell.). But when the user clicks on the total value, then no filtering happens.. so may trigger fails.

Am thinking of keeping a transparent text box on the totals value and implement but not sure if its the only way. Please help.

Re: Trigger when clicked on a pivot table.

avinashelite — Wed, 25 Oct 2017 09:30:23 GMT

if you want this functionality on all the cells then I think that is way to do that " keeping a transparent text box on the totals value" or you could try with macro on that chart alone

Re: Trigger when clicked on a pivot table.

Anonymous — Wed, 25 Oct 2017 09:38:57 GMT

Thank you, Avinash. But, Am very poor at macros. I can use some help. Or if there any other ways around.

Re: Trigger when clicked on a pivot table.

avinashelite — Wed, 25 Oct 2017 09:54:25 GMT

check this its close to your requirement but not the exact one which your looking for

Opening a Sheet based on the click of a selecte... | Qlik Community