Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
evgeniystuchalk
Contributor II

Pivot Table Sorting

Hello! I have pivot table, with two row dimensions. I'm sorting all dimensions with formula:

sum(${<[Date Type]={'Deal Close'}, Win=-{0}>}  [Amount]), by decease.

But order of sorting is broken, as result. I'm find out that it happens because some level-2 dimension values cross with several level-1 dimension values. If i'm select only one level-1 dimension value, sorting works fine.

508bf58874.jpg

How to change formula, for sort order respect measure value in current table secion?