Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

1 Solution

Accepted Solutions
jagan
Partner
Partner

Hi,

Try like this

Temp:

LOAD

*,

Ceil(RecNo()/2) AS RecNo

INLINE [

ID, DATE, CODE

100, 01/05/2012 11:15, 1

100, 01/05/2012 11:35, 2

100, 12/08/2013 10:50, 1

100, 13/08/2013 10:23, 2

100, 15/10/2014 12:32, 1

100, 25/10/2014 16:18, 2];

Data:

LOAD

ID,

RecNo,

DATE AS 1

RESIDENT Temp

WHERE CODE = 1;

LEFT JOIN(Data)

LOAD

ID,

RecNo,

DATE AS 2

RESIDENT Temp

WHERE CODE = 2;

DROP TABLE Temp;

Regards,

Jagan.

View solution in original post

1 Reply
jagan
Partner
Partner

Hi,

Try like this

Temp:

LOAD

*,

Ceil(RecNo()/2) AS RecNo

INLINE [

ID, DATE, CODE

100, 01/05/2012 11:15, 1

100, 01/05/2012 11:35, 2

100, 12/08/2013 10:50, 1

100, 13/08/2013 10:23, 2

100, 15/10/2014 12:32, 1

100, 25/10/2014 16:18, 2];

Data:

LOAD

ID,

RecNo,

DATE AS 1

RESIDENT Temp

WHERE CODE = 1;

LEFT JOIN(Data)

LOAD

ID,

RecNo,

DATE AS 2

RESIDENT Temp

WHERE CODE = 2;

DROP TABLE Temp;

Regards,

Jagan.