Qlikview Sorting

[#1]

Hi All,

I have used  custom sorting to enabe the sorting on week.Its working fine till any week is not selected .When any value(week) is selected from the dropdown ,the sorting fails.

Kindly help me in solving the issue

[vikasmahajan]

If you are using Pivot Table then QV sorts only on first stage ,  you can give expression in sort option or y value.

Vikas

[#3]

Hi Vikas,

I am using Multibox and I have given expression as =Sort_Order (Which is used in Inline Table).

[CELAMBARASAN]

Hi,

try with this

=Max({1}Aggr(Max({1}Sort_Order), FieldName))

Hope it helps

Celambarasan