Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

.NET SDK GetTable and Totals

Hi,

I'm connecting to a Sense App using the .NET SDK, and getting tabular data by calling the ISheet member CreateTable, passing in a random string and table properties as parameters.

The table properties has a HyperCubeDef of a dimension and measures, and a parameter of type TableTotals:


Totals = new TableTotals

{

     Position = TableTotalsPosition.Top,

     Label = "Totals",

     Show = true

}

I get data out from the table using the GetTable method and then calling GetData.

I'd like to also get the totals, and I have done so using this after calling GetTable(...):

var grandTotalCells = table.GrandTotalRow;

In my app, I have 4 table cells and 2 totals cells.  How do I know for which table cell the total cell corresponds? (so are the totals relating to cell 1, cell 2, or something else?)

ALSO:

In Sense, I am able to set a 'totals function' - how can I use this in code?

Thanks and regards,

Shane.

Tags (4)
2 Replies
Not applicable

Re: .NET SDK GetTable and Totals

Hi,

The total cells are in the same order as the measures in the hypercube.

The "totals" is a custom property. Set the function in myTable.Property.Totals.Label and you will

have the result in myTable.Totals.Label.

Best Regards

Lars-Göran Book

Not applicable

Re: .NET SDK GetTable and Totals

Hi,

is that kind of thing possible with the CreateTable/GetTable method calls?  Or do I need to take another approach?

A code sample would be a fantastic help

Thanks,

Shane.

Community Browser