topic Re: sort basing on id value in QlikView

sort basing on id value

JMAROUF — Wed, 25 Nov 2020 16:16:04 GMT

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;

Re: sort basing on id value

Gysbert_Wassenaar — Sat, 18 May 2019 14:13:45 GMT

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

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

DROP TABLE temp;

Re: sort basing on id value

JMAROUF — Sat, 18 May 2019 14:28:37 GMT

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.

Re: sort basing on id value

Gysbert_Wassenaar — Sat, 18 May 2019 16:00:49 GMT

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;

Re: sort basing on id value

JMAROUF — Sat, 18 May 2019 16:55:35 GMT

thank you @Gysbert_Wassenaar your solution has solved my problem.