Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Pivot table sorting trouble

Hello! I ahave a pivot table with a lot of dimension.

all of them must be sorted, descending, by expression.

It mostly works fine, but for some dimensions sorting shows strage things (marked with red).

I know it happens because values of this dimension not unique for this level. How i must change sorting expression, to make it works only in current level, not over all levels at same time?

Current expression is:

sum({$<[Тип даты]={'Закрытие сделки'}, Win=-{0}>} [Единиц техники])

03d1e2957f.jpg

0 Replies