topic Re: Sort Straight table based on expression with Drill down Dimension group in QlikView

Sort Straight table based on expression with Drill down Dimension group

psankepalli — Mon, 18 May 2015 15:14:09 GMT

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

Re: Sort Straight table based on expression with Drill down Dimension group

Anonymous — Mon, 18 May 2015 19:02:51 GMT

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.

Re: Sort Straight table based on expression with Drill down Dimension group

psankepalli — Mon, 18 May 2015 19:11:56 GMT

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.

Re: Sort Straight table based on expression with Drill down Dimension group

Anonymous — Mon, 18 May 2015 20:03:09 GMT

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