topic Qlik Extension: get all data regardless of selection in Integration, Extension & APIs

Qlik Extension: get all data regardless of selection

Anonymous — Thu, 12 Jan 2017 20:04:53 GMT

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

Re: Qlik Extension: get all data regardless of selection

websy1985 — Thu, 12 Jan 2017 20:14:55 GMT

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

Re: Qlik Extension: get all data regardless of selection

Anonymous — Wed, 18 Jan 2017 18:29:09 GMT

Nick,

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

Gregory