topic Determine which column was clicked in OnSelect in QlikView

Determine which column was clicked in OnSelect

Tue, 09 Nov 2010 17:40:27 GMT

I have some script that displays a chart when a selection is made in a different chart. Here's the columns in the first chart (a sales table):

UserID | Order ID | ProductID

So if a users clicks a UserID from the above chart, then another chart pops up showing some information about that UserID. Like this:

FirstName | LastName | Address | so on...

My issue is that I want a different chart to pop up if the user selects ProductID to show some information about that product.

So if i grab the chart:

c=ActiveDocument.GetSheetObject("CH575")

How can I tell that the user selected a UserID vs a ProductID. Or maybe this info is saved in a sheet object?

Thanks!

Determine which column was clicked in OnSelect

johnw — Tue, 09 Nov 2010 18:55:33 GMT

Maybe you could check for what is now selected, rather than what they clicked on.

getselectedcount(ProductID)

Determine which column was clicked in OnSelect

Tue, 09 Nov 2010 22:12:16 GMT

Hi John,

That kind of works expect if there is already a UserID selected then a ProductID is selected. The you have both selected but I want to show the chart for whatever the user clicks last. I guess it really just goes against the way Qlikviews meant to be used.