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

The this.Data.SelectRow(i) method?

Been scratching my head for a while now.

How does this function actually work?

I've done a custom map-sort of extension, using html AREA-tags for defining the interactive areas on an image aswell as jquery for doing some highlighting. I've managed to get it working one way: choosing different fields in the listboxes to show the corresponding areas in the map as highlighted.

But the other way isn't working. I want to select an area in my map and then automatically select the corresponding fields in the listbox. For example, choosing the area "main park" in my image with an ID of 3 would automatically select the field "3" in my listbox with ID:s.

To get the simpliest to work, I've tried the following without success.

Qva.AddExtension('testAreaMaps', function()

{       

          this.Data.SelectRow(3);

          ...

          ...

}

To automatically highlight that field in my listbox when i refresh my extension.

Any ideas?

best regards.

1 Solution

Accepted Solutions
Not applicable
Author

You should use the Data.SelectValuesInColumn(columnIdx, values, toggle, isFinal) function instead.

columnIdx is the index of the dimension you want to make your selection into

values is a string containing a comma separated list of values to select

toggle is true if you want to toggle the values selection state instead of forcing them to be selected

isFinal is used to selection with several calls to the method, the selection will be done when this parameter is true (first versions were limited to 40 possible values by call but latest version does not seem to have this limitation so I don't think it is very useful to do several calls anymore)

View solution in original post

5 Replies
Not applicable
Author

You should use the Data.SelectValuesInColumn(columnIdx, values, toggle, isFinal) function instead.

columnIdx is the index of the dimension you want to make your selection into

values is a string containing a comma separated list of values to select

toggle is true if you want to toggle the values selection state instead of forcing them to be selected

isFinal is used to selection with several calls to the method, the selection will be done when this parameter is true (first versions were limited to 40 possible values by call but latest version does not seem to have this limitation so I don't think it is very useful to do several calls anymore)

Not applicable
Author

That worked like a charm! Thank you so much 😄

Where do I find all these functions? I bet there's plenty more of them

cheers

Not applicable
Author

Hi gabrielh,

The QlikView AJAX/JavaScript API reference can be found in the QlikView SDK. RIght now you can get the SDK by installing the QlikView Server and choosing Custom Install.

Now that we have the new improved QlikCommunity platform we are working to host the SDK here and that should be up in a couple of weeks. 

Regards,

Dan

Miguel_Angel_Baeyens

That's very good news! Very convenient.

deh wrote:

Now that we have the new improved QlikCommunity platform we are working to host the SDK here and that should be up in a couple of weeks.

Regards

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

Roger that, thank you!