Line Ordering and Sequence Variation

Wed, 22 Apr 2015 22:24:57 GMT

Hi,

This is my first post here, sorry about my bad English and if i mistake something here. I would like some help in the problem below.

I have a database with 5 date columns, and i need to put each line in a crescent order, and know the types of sequence variation that i have like the tables below:

Data base Example:

Date1	Date2	Date3
01/01/2015	02/02/2015	15/01/2015
02/02/2015	01/01/2015	15/01/2015
02/02/2015	15/01/2015	01/01/2015

Put in order:

Column1	Column2	Column3
01/01/2015	15/01/2015	02/02/2015
01/01/2015	15/01/2015	02/02/2015
01/01/2015	15/01/2015	02/02/2015

Types of variation:

Column1	Column2	Column3
Date1	Date3	Date2
Date3	Date1	Date2
Date3	Date2	Date1

Re: Line Ordering and Sequence Variation

petter — Wed, 22 Apr 2015 23:28:46 GMT

This might be a solution for you:

Re: Line Ordering and Sequence Variation

Wed, 22 Apr 2015 23:44:09 GMT

Awesome Petter!

Thank you very much!

topic Re: Line Ordering and Sequence Variation in QlikView

Line Ordering and Sequence Variation

Re: Line Ordering and Sequence Variation

Re: Line Ordering and Sequence Variation