Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasannappt
New Contributor II

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
Employee
Employee

Re: how to Sort IEnumerable<NxCellRows>

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...

Community Browser