topic Re: Sort by expression in QlikView

Sort by expression

vvvvvvizard — Mon, 29 Jan 2018 06:34:41 GMT

I have a pivot table with two dimensions Region and Department and two expressions Sum(Actual) and Sum(Budget)

For the region i have them sorted by expression as region 1 , 2 , 3, admin ect

Now how do i sort the department within each region . I want to sort them by the smallest difference between expression 1 and two first

actual budget

eg region 1 depart10 100 99

depart 8 50 84

depart 3 2 100

region 2 depart 5 80 100

depart 2 10 90

so the department with smallest difference between actual and budget must be first for each region .

Please assist

hhajjali — Mon, 29 Jan 2018 06:39:03 GMT

Hello,

In sort parameters first put region, then department, then actual, then budget.

In department sort, set by expression, and in the expression :

[Budget]-[Actual].

Hope it help.

jonathandienst — Mon, 29 Jan 2018 06:47:50 GMT

Switch the sort for department to Expression (ascending) , and enter the difference expression - something like

=Sum(..... Actual) - Sum(..... Budget)