straight table sort by a expression column issue

[wenkew186]

hi all,

I have a straight table. 1 dim and 7 expression. 1 of the expression column is date format.

I need sort by the column for this table always, so I don't need "Allow Interactive Sort"  and I uncheck it.

ok, I let the column name to top of the list in Sort tab. and set the Sort by ='Numeric Value' ------'Ascending'

Then, look like good for the sort of the table on my desktop.

But, when I put the dashboard to Server, and refresh by QMC, and I check the dashboard on access point web page, the sort is not work. and then I checked the qvw  file on server, the dim has in top of the list in Sort tab.

So, the problem is sort by Expression column not work on access point web page.

Have any suggestion to me ?  Thank you so much! 

[Gysbert_Wassenaar]

You can try enabling the Sort by Y-value for the dimension. Promote the expression you want to sort by to the top spot on the Expressions tab. If you want to show that expression in the original position in your table then make a copy of it, put the copy in the top spot and hide that column on the presentation tab.

[wenkew186]

Hi Gysbert,

Thank you attention to the question.

My table is a straight table, not sort by Y-value.