Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
JMAROUF
New Contributor II

sort basing on id value

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;

Tags (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: sort basing on id value

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;


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: sort basing on id value

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

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

DROP TABLE temp;


talk is cheap, supply exceeds demand
JMAROUF
New Contributor II

Re: sort basing on 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.

MVP & Luminary
MVP & Luminary

Re: sort basing on id value

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;


talk is cheap, supply exceeds demand
JMAROUF
New Contributor II

Re: sort basing on id value

thank you @Gysbert_Wassenaar  your solution has solved my problem.