topic Re: Sorting Pivot table... again... in App Development

Sorting Pivot table... again...

micheledenardi — Fri, 15 Jun 2018 13:59:35 GMT

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 ?

Re: Sorting Pivot table... again...

isingh30 — Fri, 15 Jun 2018 18:15:33 GMT

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

Re: Sorting Pivot table... again...

micheledenardi — Mon, 18 Jun 2018 07:31:33 GMT

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.

Re: Sorting Pivot table... again...

brunobertels — Mon, 18 Jun 2018 10:04:04 GMT

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

Re: Sorting Pivot table... again...

micheledenardi — Mon, 18 Jun 2018 10:17:39 GMT

Bruno, no, this is not what i want.

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