Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

evgeniystuchalk
Contributor 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

Community Browser