Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all i have 10 rows then
my question is like
1.add row
2.remove the row
3.10 the row move to on top 1st,
4. 1st rows will be 10th
QlikView is not Excel and will never be. So if you are aiming at doing manual row manipulation interactively you will probably never see that in this product.
However there are ways to get the row ordering in a different way by various means - non-interactively by use of the data model and or dimensions and expressions.
In a Straight Table the dimensions and expressions determine the row order by setting the sort order in the properties of the Straight Table chart. If none of the existing dimensions or expressions would give the right sort order then you can either introduce an additional field as a dimension and "hide" the column but use it as the one to determine sort order - or you can make use of Dual() function to make a text field into a dual-value field having both a text part and in addition a numeric part. The numeric part of the field will then determine the sort order for the field.
An additional question... what is the purpose of this and what is the use-case for it. Could you give a more detailed example.