Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
wenkew186
Contributor

straight table sort by a expression column issue

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! 

2 Replies
MVP & Luminary
MVP & Luminary

Re: straight table sort by a expression column issue

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.


talk is cheap, supply exceeds demand
wenkew186
Contributor

Re: straight table sort by a expression column issue

Hi Gysbert,

Thank you attention to the question.

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