Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Bot Net - Access Hypercube data

Hi All,

Im trying to build Skype Bot with Qlik, Connection established with QLik and i can see the sheets listed in .qvf file,

Can anyone help me in creating hypercube code to retrieve dimensions data in c# code,

This is the sample code i use in jquery to create hypercube and use in html.

      app.createCube({

                qDimensions: [

                    { qDef: { qFieldDefs: ["ROLEQUESTIONS"] } }

                ],

                qMeasures: [

                    { qDef: { qDef: "only({<ROLENAME={'$(vRoleName" + variablePeople + ")'}, ISACTIVE={'Y'}>} SHEETID)", qLabel: "" } }

                    , { qDef: { qDef: "only({<ROLENAME={'$(vRoleName" + variablePeople + ")'}, ISACTIVE={'Y'}>} ROLERANK)", qLabel: "" } }

                     } }

                ],

                qInitialDataFetch: [{ qTop: 0, qLeft: 0, qHeight: 200, qWidth: 9 }]

            }, QuestionRender);

        }

        function QuestionRender(reply) {

var questionID = reply.qHyperCube.qDataPages[0].qMatrix[key][3].qText;

}

2 Replies
Anonymous
Not applicable
Author

Can any share your views

Øystein_Kolsrud
Employee
Employee

Hi! It looks like this project could be of use to you: Qlik Branch