Sorting Pivot table... again...

[micheledenardi]

Hi,

by using qliksense 3.0.2 i'm unable to sord in desc order the second dimension of a pivot table.

I've tried different solution on like:

- sum([BOM Material Q.ty])

- aggr(rank(sum([BOM Material Q.ty])), [BOM Material])

- Sum(total <[BOM Material]>[BOM Material Q.ty])

- RANK(Sum([BOM Material Q.ty]),3)

- Aggr(Sum([BOM Material Q.ty]),[Material],[BOM Material])

But nothing seems work....

I've attached the qvf with the data.... can anyone help me ?

[isingh30]

Try with Group & order by function in the main script.

[micheledenardi]

Already tried but it seems not working... in the real data model "Bom Material" and "Material" are located in two different tables with 2 tables between them...

I would like to resolve this problem by using a formula in the layout sort order tab.

[brunobertels]

Hi

Is this what you want ?

If Yes use this expresison in sort order menu :

MAterial :

Auto

BOM Material : personalized

aggr([BOM Material],(Material,(NUMERIC, ASCENDING)))

[micheledenardi]

Bruno, no, this is not what i want.

I want to order dimensions by measure and not by dimension value.