Qlik Community

Ask a Question

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlik Extension: get all data regardless of selection

All,

I am creating an organigram extension that shows different behavior than a standard Qlik Sense extension. Instead of showing only the nodes that correspond to the user's current selection, I would like to always draw the complete organigram and to highlight the nodes corresponding to the user's selection.

The challenge is that the hypercube of the extension object only contains the data corresponding to the user's selection, which makes it impossible to first draw the complete organigram and subsequently to highlight the selected nodes. I found a workaround by using the Engine API's method: getTableData which returns all the data in the organigram table regardless of the selections. The problem is however that the returned data does not contain the qElemNumber, required to be binded to a node in the organigram to make it selectable.

Do you guys know any other workaround that would allow me to neglect the current selection and to get all the data, including the qElemNumber? I assume it is possible, as there exists a qStatus field in the hypercube that indicates the selection state of the data. But I don't know how to make the excluded rows visible.

Thanks in advance,

Gregory

1 Solution

Accepted Solutions
Luminary
Luminary

Hi Gregory,

Take a look at this extension on Qlik Branch that I put together - Qlik Branch

It uses alternate states to create a duplicate HyperCube which isn't affected by the selections. That means you get a HyperCube which always has all of the data and another one with just the data applicable to current selections. Using the 2 you can calculate which values to highlight when you render the visualisation.

I hope that helps.

Thanks

Nick

View solution in original post

2 Replies
Luminary
Luminary

Hi Gregory,

Take a look at this extension on Qlik Branch that I put together - Qlik Branch

It uses alternate states to create a duplicate HyperCube which isn't affected by the selections. That means you get a HyperCube which always has all of the data and another one with just the data applicable to current selections. Using the 2 you can calculate which values to highlight when you render the visualisation.

I hope that helps.

Thanks

Nick

View solution in original post

Contributor III
Contributor III

Nick,

Exactly what I was looking for. Thanks for your answer!

Gregory