Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to prepare the data for the pivot table?

We're making some pivot table extension which uses 4 dimensions and one measure. The First two dimensions should not be shown anywhere, they are used only for bolding some total rows, and for sorting. My question is, how to prepare the data for the pivot table, is there an extended qHypercube method, or some method in the qlik extension api. For now we prepared data by ourself, without any qlik method, but the data sorting is wrong.

pivot.png