Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to let the user manually sort the rows of a table , like the user can rearrange columns ( without forcing the user to introduce an artificial index just to impose a sort order ).
thanks
It is possible to have an interactive sort of a column within a straight table, check the 'allow interactive sort' box on the sort tab of the table properties.
Like Leonard says you can let the users sort interactively.. however it sounds like you're trying to let the users create any kind of sorting they want, like 2005, 2008, 2006, 2009, 2007, or some other kind of unconventional series.
In that case I think you'll have to rely on an artifical sorting index. Otherwise QlikView won't know what you're looking for.
Yes, this was what I meant.
I usually solve that introducing a artificial index, but I don't like this solution because it introduce an unrelated field in the data model just to support sorting. Additionally, it is not interactive.
Other products have this kind of option (the user just click UP / DOWN buttons on some list boxes with distinct values to impose the priority they want for the values and then the tool just generate ordering for you under the hood that can be used in other components like tables ).
I'm not sure if the original author still has a need for this, but I recently decided to play around with this as well. For those interested, check out this article: http://www.infinityinsight.com/blog/?p=243
Cheers,
Vlad