2 Replies Latest reply: Sep 18, 2018 5:25 AM by Øystein Kolsrud RSS

    Qlik Bot Net - Access Hypercube data

    Ravichandran Raju

      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;

      }