Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to Sort IEnumerable<NxCellRows>

Hi All,

     Am facing problem with sorting , in qlik Engine NxCellRows , am trying to sorting below my code part is

                        IAppField fID = qsApp.GetAppField("FieldName");

                        var p = new List<NxPage> { new NxPage { Height = 100000 } };

                        var dataPages = fID.GetListObjectData("/qListObjectDef", p);

                        foreach (var dataPage in dataPages)

                        {

                                 var matrix = dataPage.Matrix;  // i want sort this matrix

                        }

please help me to archive this

Thanks

1 Reply
Øystein_Kolsrud
Employee
Employee

There are settings in the ListObject property of the AppField that can be modify to control the sorting. You'll find the settings in this structure:

https://help.qlik.com/en-US/sense-developer/February2018/apis/net+sdk/html/P_Qlik_Engine_ListObjectD...

In particular, these properties are the ones that aught to be of interest to you:

https://help.qlik.com/en-US/sense-developer/February2018/apis/net+sdk/html/P_Qlik_Engine_NxInlineDim...

https://help.qlik.com/en-US/sense-developer/February2018/apis/net+sdk/html/P_Qlik_Engine_NxInlineDim...

It's conceptually the same as the sorting done for hypercubes, so you should be able to use this example as a reference:

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