Sort Straight table based on expression with Drill down Dimension group

[psankepalli]

Experts,

I have a scenario,

I have a straight table with Drill down group as dimension and and few expressions.

I want sort table by default based on the expression.

I am trying to sort a straight table using my first expression - I don't want to change the script.

It works fine initially but when the document gets reloaded the sort order is reset to the first dimension (From Drill down group) and I have to do it all over again.

is there any limitaion with the Qlikview? or there is any solution.

Please help me

Thanks

[Anonymous]

I cannot reproduce your problem.

Anyway, try to sort the drill-down group by your expression.  You'll to check "override group sort order" first to do this.

[psankepalli]

Thank you for your quick reply.

Every thing working fine at my Desktop application, even after I reload it many times. its working fine. But When I publish/Refresh the application @ Access Point its not sorting based on Expression, its sorting based on first dimension. I read it in blogs its kind of Bug and got fixed in QV 11.20 SR11 (I am really not sure) . Please let me know if you have any clues on it.

[Anonymous]

Well, if it happens on server, I can't test it...  But - did you try my suggestion to sort the group itself by expression?