Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Who Me Too'd this solution

sunny_talwar
MVP
MVP
‎2016-03-06 04:11 PM

May be this:

Table:

LOAD Id,

    StartDate

FROM

[https://community.qlik.com/thread/208361]

(html, codepage is 1252, embedded labels, table is @1);

FinalTable:

LOAD Id,

  StartDate,

  If(Id = Peek('Id'), Date(Peek('StartDate') - 1)) as EndDate

Resident Table

Order By Id, StartDate desc;

DROP Table Table;


Capture.PNG

View solution in original post

Community_208361.qvw
1 user say ditto
4,091 Views
Who Me Too'd this solution