Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

Sorting Pivot table... again...

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 ?

2018-06-15 15_50_56-test - Il mio nuovo foglio (1) _ Fogli - Qlik Sense.png

4 Replies
isingh30
Specialist
Specialist

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

micheledenardi
Specialist II
Specialist II
Author

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
Specialist II
Specialist II

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

Capture.PNG

Capture.PNG

micheledenardi
Specialist II
Specialist II
Author

Bruno, no, this is not what i want.

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