Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try with Group & order by function in the main script.
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.
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)))
Bruno, no, this is not what i want.
I want to order dimensions by measure and not by dimension value.