Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to add,remove and adjusted the rows

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 

2 Replies
petter
Partner - Champion III
Partner - Champion III

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.

petter
Partner - Champion III
Partner - Champion III

An additional question... what is the purpose of this and what is the use-case for it. Could you give a more detailed example.