Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Sorting problem with last and before

Hi all,

I am calculating the $ Change column with this expression

=(before( sum(Balance), 1 ) - sum(Balance))


Now the problem is, I want to sort this in ascending order, basically find out which account has the most declined balance.

I tried the following expressions for sorting but both do not seem to be working.

=(before( sum(Balance), 1 ) - sum(Balance))


or

=last( (before( sum(Balance), 1 ) - sum(Balance)))


Has anyone had any luck getting this working before?

error loading image

Community Browser