sort basing on id value

[JMAROUF]

Hello everyone,

can any one help please,  i want to load values sorted basing on the id, i want exactly the result in the attachment:

It is possible in Qlikview ?

best regards;

[Gysbert_Wassenaar]

temp:
LOAD ID, Value FROM ...source... ;

Sorted:
NOCONCATENATE LOAD ID, Value RESIDENT temp ORDER BY ID, Value;

DROP TABLE temp;

[JMAROUF]

thank you for answer, but how can i get the third line ( number  row ) per id value , i want exactly the result in attachment. for each id value i want an incremented value.

[Gysbert_Wassenaar · Accepted solution]

temp:
LOAD ID, Value FROM ...source... ;

Sorted:
NOCONCATENATE LOAD ID, Value, AutoNumber(Value, ID) as rownumber RESIDENT temp ORDER BY ID, Value;

DROP TABLE temp;

[JMAROUF]

thank you @Gysbert_Wassenaar  your solution has solved my problem.