Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lblancher
Partner - Contributor III
Partner - Contributor III
‎2019-03-27 09:46 PM

.Net SDK Sort HyperCubeDef

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

Labels (1)
Labels
514 Views
0 Likes
1 Reply
Øystein_Kolsrud
Employee
Employee
‎2019-03-28 04:44 AM

This example illustrates how to do sorting of hypercubes:

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

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.

500 Views
0 Likes