Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Thanks

Sekhar

1 Reply
danielrozental
Master II
Master II

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.