Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Pivot table Context

Is there any way I can get the pivot table intersection in VBScript? I would like to get the context before and after the click.

Actually, what I want to do is to set the row and column selections to row and column intersection in the pivottable. I see that if I click on Row A and Col B

the selection is fine. If I then click on Row A and Col C, the value of the Row is toggled out and the selection for the row is blanked out. Instead I want the variables to be set to Row A and Col C.

I was thinking to implement this in VBScript. But I am not able to get the context of the cell where the user clicked.

Please let me know how I can implement this - whether with VBScript or any other configuration changes.



Tags (1)
1 Reply
Honored Contributor II

Pivot table Context

Not sure I got what you're trying to achieve but I have a couple ideas that might help you.

You can have a document level trigger on Row and Col selection then store into a variable the selection.

You can use previous selection in set analysis sum({$1} Sales) will return the sales of the previous selection.