Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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