Discussion board where members can get started with QlikView.
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 ?
Go to 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;
Sorted:NOCONCATENATE LOAD ID, Value RESIDENT temp ORDER BY ID, Value;
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.
thank you @Gysbert_Wassenaar your solution has solved my problem.