.Net SDK Sort HyperCubeDef

lblancher — Sat, 16 Nov 2024 06:13:52 GMT

Hello,

I working on a C# application that creates a HyperCube and then reads the results into a DataTable. I've been able to get Dimensions and Measures working, but I'm having an issue sorting the results. Is there a way with the .Net SDK to sort the HyperCube rows by Expression?

It looks like the javascript libraries have this ability but i don't see anything for the .Net SDK.

Any suggestion on where i could find the documentation on how to sort a HyperCube by expression?

Regards,

Lucas

Re: .Net SDK Sort HyperCubeDef

Øystein_Kolsrud — Thu, 28 Mar 2019 08:52:02 GMT

This example illustrates how to do sorting of hypercubes:

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/blob/master/HypercubeUsage/Program.cs#L195

The three main properties of interest are the "SortCriteria" for dimensions, "SortBy" for measures, and the "InterColumnSortOrder" for the hypercube it self that controls the order in which the columns should be sorted.

topic .Net SDK Sort HyperCubeDef in Integration, Extension & APIs

.Net SDK Sort HyperCubeDef

Re: .Net SDK Sort HyperCubeDef