topic Re: qlik sense accessing charts in qlik app c# in Integration, Extension & APIs

qlik sense accessing charts in qlik app c#

Anonymous — Wed, 06 Dec 2017 12:45:21 GMT

Hi all,

I want to access each and every graph inside qlik sense app by using .netSDK. I am new to c# If someone could help me with the sample code(easy to understand) that'll be great.

Re: qlik sense accessing charts in qlik app c#

ruanhaese — Wed, 13 Dec 2017 09:03:00 GMT

The QlikBot .NET code was released yesterday showing the .NET code

of how to use the APIs together with the Bots.

It's a Qlik Bot invasion!

Think this is a good starting point to answer the question.

Looking in the QlikSenseEasy -> QSEasy.cs file

on what it is that you are specifically looking for

Re: qlik sense accessing charts in qlik app c#

ruanhaese — Wed, 13 Dec 2017 09:06:22 GMT

But basically its going to be something like

...

IApp app = qsLocation.App(myAppID)

then

app.GetMasterObjectList().Items?.Select(item => app.GetObject<MasterObject>(item.Info.Id));

and then convert that object to a respective sheet, chart, etc

Re: qlik sense accessing charts in qlik app c#

Anonymous — Wed, 13 Dec 2017 09:26:48 GMT

Raun thanks for your prompt reply. Sinse I am new to c# as well as qlik sense if you could give me code example that would be great.

Re: qlik sense accessing charts in qlik app c#

ruanhaese — Wed, 13 Dec 2017 09:39:43 GMT

The code for all of it is a bit long (the QSEasy file is over 2000 lines) and I'm not sure what your specifically looking at.

Its a good idea to go through the QSEasy.cs file but basically make sure that

- you import the Qlik API's

- reference them with the using Qlik.Engine, Qlik.Sense, etc

- initiate the app

Read this article to connect/some extra info

Re: QlikSense Desktop Chat Bot

And then check the code for one of them like CreatePieChart

Re: qlik sense accessing charts in qlik app c#

Anonymous — Wed, 13 Dec 2017 09:44:48 GMT

As you know In qlik app there are multiple sheet and each sheet contain multiple objects(bar chart, pie chart or any other type). I am able to get the object ID and I am also able to find out if it is barchart or piechart but I want to access data within that chart(text or chart doesn't matter).

Re: qlik sense accessing charts in qlik app c#

ruanhaese — Wed, 13 Dec 2017 10:11:21 GMT

From my understanding of the API's, how they are built is not so much to access an individual object and its data.

You should rather research how to create a hypercube with the same dimensions and measures,

which would replicate the data from that table.

It might be possible to extract the data from an object, I'm just not sure how to do this myself.

Still learning a lot here as well.

The best is to look at the QlikBot example.

Re: qlik sense accessing charts in qlik app c#

Anonymous — Wed, 13 Dec 2017 10:20:40 GMT

IEnumerable<ISheet> sheets = qsApp.GetSheets();

foreach (ISheet sheet1 in sheets)

{

Console.WriteLine(sheet1.GetBarchart("qZPdytp")); #getbarchart requires object id

}

output in console is: Qlik.Sense.Client.Visualizations.Barchart

and also tell me what exactly hypercube class is used for and there are multiple hypercube classes in api which one to start with.

Re: qlik sense accessing charts in qlik app c#

Todd_Margolis — Wed, 13 Dec 2017 15:29:53 GMT

You can access the data of any Qlik object via its Hypercube. Here is how to get all of the sheet objects:

foreach (IGenericObject child in sheet.Children) {  
     Console.WriteLine("Type:{0} ID:{1}", child.Info.Type, child.Info.Id); 
}

Once you have the objects, you can retrieve the paged data as so:

var first10RowsPage = new NxPage { 
     Top = 0, Left = 0, Width = myObject.HyperCube.Size.Cx, Height = 10 
};
IEnumerable<NxDataPage> data = myObject.GetHyperCubeData(“/qHyperCubeDef”, new [] { first10RowsPage });

Please review our Help site for detailed documentation.

Re: qlik sense accessing charts in qlik app c#

Anonymous — Thu, 14 Dec 2017 05:11:32 GMT

Thanks Todd but I already got this code on qlik website but I am not able to implement it.

Here is my code:

foreach (Qlik.Sense.Client.ISheet AppSheet in Qlik.Sense.Client.AppExtensions.GetSheets(qsApp))

{

foreach (IGenericObject child in AppSheet.Children)

{

Console.WriteLine(child.Info.Type, child.Info.Id);

var first10RowsPage = new NxPage {

Top = 0, Left = 0, Width = child.HyperCube.Size.Cx, Height = 10

};

IEnumerable<NxDataPage> data =child.GetHyperCubeData(“/qHyperCubeDef”, new [] { first10RowsPage });

}

Re: qlik sense accessing charts in qlik app c#

ruanhaese — Thu, 14 Dec 2017 11:52:37 GMT

Change the child back to myObject

then before the "first10RowsPage" add

GenericObject myObject = (GenericObject)child; //converts it from an IGenericObject to GenericObject which contains Hypercubes

Seems to get something to work, but also still playing around with it myself

foreach (IGenericObject child in AppSheet.Children)

{

Console.WriteLine(child.Info.Type, child.Info.Id);

GenericObject myObject = (GenericObject)child;

var first10RowsPage = new NxPage {

Top = 0, Left = 0, Width = 10, Height = 10

};

IEnumerable<NxDataPage> data = myObject.GetHyperCubeData(“/qHyperCubeDef”, new [] { first10RowsPage });

}

Re: qlik sense accessing charts in qlik app c#

Anonymous — Fri, 15 Dec 2017 05:31:44 GMT

I am getting error..I guess it is not able to find the path "/qHperCubeDef"

Re: qlik sense accessing charts in qlik app c#

ruanhaese — Fri, 15 Dec 2017 07:02:54 GMT

Check your spelling on "qHperCubeDef"

Re: qlik sense accessing charts in qlik app c#

Anonymous — Fri, 15 Dec 2017 07:31:29 GMT

It is correct "/qHyperCubeDef". I did spelling mistake in my last reply but in my code it is correct.

Re: qlik sense accessing charts in qlik app c#

Øystein_Kolsrud — Fri, 15 Dec 2017 10:51:46 GMT

Not all objects have hypercubes, and since you are traversing all objects of an app, I would think it quite likely that you have run into one that doesn't. The pager class is quite useful for interacting with hypercubes (and list objects). You could do something like this instead:

var pager = myObject.GetAllHypercubePagers().FirstOrDefault();
if (pager != null)
  var data = pager.GetData();

More information can be found here:

IGenericObject.GetAllHyperCubePagers Method

Paging of data ‒ Qlik Sense Developers

And here (but considering your example, I'd guess you've already seen this):

Retrieving data ‒ Qlik Sense Developers