App Development

[kavirao]

Hi ,

I need help to render pivot table data into mashup using hyper cubes.  I need example how to render data of pivot table in return function. 

I need some sample to code loop through 2 dimension and 1 measure to show as below pivot table in html.

function Pivot_Risk(reply, app){
console.log(reply);
console.log(reply.qHyperCube.qPivotDataPages[0].qData);

});

Company	Q1	Q2	Q3	Q4
A	8	4	0	7
B	2	0	5	2
C	0	3	0	0
D	0	0	2	0
E	0	2	0	4
F	1	0	3	2
Total	11	9	10	15

Thank you 

[AJ_Ruggiero]

Hi @kavirao,

Does the following article answer your question:

https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Pivot-Table-with-the-new-GetHyperCubeTreeD...