Sort by Expression not working

[#1]

I'm using QlikView 9 SR5. I'm trying to sort a straight table by one of the columns using an expression, but the sort isn't working.

The expression I am using to sort is the same as the expression for the column. However, the column ignores the expression and is always sorted the same way no matter how many times I double-click the column header.

Is this a bug in QlikView or am I missing something basic? I've attached a simple test case to illustrate the problem. To see the behavior, try to sort the sum(Field1) column by double-clicking the header, The order doesn't change.

Thanks!

[erichshiino]

I have the same QV Version that you do, but I can sort it with the double-click. So, I dont know what happened to you.

I had this problem before. Try to enter in chart properties -> Sort Tab and for the expressions do not mark the "Text" Box. Use only Numeric Value

[#3]

Erich, thanks for responding.

Sorry, I uploaded the wrong app. Please see this one.

The problem I am having is that sort by Expression does not work. I know how to sort by numeric and text value, but that is not what I need to do. I need Sort by Expression to work.

[m_woolf]

I sorts fine for me when I dbl click the column header in V9SR6

[#5]

Simon,

Sort by expression will work for the ID field in your sample app. I believe it needs to be a dimension for it to let you sort by an expression but I could be mistaken.

You will want to promote it in the sort order & I also recommend turning off interactive sort when you want to force a specific sort order. See attached