topic Re: Sorting of Pivot Table Dimension based on Expression. in QlikView

Sorting of Pivot Table Dimension based on Expression.

Anonymous — Tue, 20 Dec 2016 07:56:12 GMT

Hi,

I have a question regarding a sorting of pivot table based on dimension.I have read almost all the Q&A in this community related to this question but my case is little different.

I have a dimension level wise like in hierarchy structure Node1,Node2,Node3..etc

Dimension should be sorted based expression(Numeric value) but blue highlighted dimension is behaving differently as it is comes in between 2,3 and 4.

I have attached a sample QVW along with this.

Note :I think its sorting based on dimension values Numeric value.

Thanks in Advance

Re: Sorting of Pivot Table Dimension based on Expression.

vinieme12 — Tue, 20 Dec 2016 08:26:08 GMT

What do you expect to see?? both 13/AA and 12/AA nodes are present in both Node 4 and Node 5 to me it looks correct

Re: Sorting of Pivot Table Dimension based on Expression.

Anonymous — Tue, 20 Dec 2016 09:00:26 GMT

Yes but both 13/AA and 12/AA should come below 4th and 5th level respectively not in between row.Since it has same Node Id's(but different level) it is coming in between.

Re: Sorting of Pivot Table Dimension based on Expression.

marcus_sommer — Tue, 20 Dec 2016 09:51:10 GMT

I think it could be helpful to use a dual-dimension for it - I mean to create them within the script per:

...

dual(Nodes, Depth) as Nodes

...

- Marcus

Re: Sorting of Pivot Table Dimension based on Expression.

Anonymous — Tue, 20 Dec 2016 10:26:15 GMT

Sorry ,I have tried in script level also but still its giving a same result no change in the sorting order.

Re: Sorting of Pivot Table Dimension based on Expression.

marcus_sommer — Tue, 20 Dec 2016 10:32:06 GMT

Are there not too many nodes you could sort them manually - maybe by exporting them to excel and there sorting and filtering them and then loading this sorted list within qlik before you load the nodes from a fact/dimension-table. After them you could drop this table and use then sorting to load-order within your table.

- Marcus

Re: Sorting of Pivot Table Dimension based on Expression.

Anonymous — Tue, 20 Dec 2016 13:39:05 GMT

I have tried a sorting method from script level it is not giving a result as expected.If we have two values in different node level its affecting a sorting order.

And If you have any idea can you able to post any sample data.

Thanks in advance