Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dnowebdn
Contributor
Contributor

date isseus

Date issue

1 Reply
shiveshsingh
Master
Master

Hi

 

Try this

 

F:
load Pointer, Date(Finish,'DD/MM/YYYY') as Finish, Date(Start,'DD/MM/YYYY') as Start, 1 as flag;

LOAD * INLINE [

Pointer, Finish, Start
1A, 2018-03-25 17:00:00.000, 2018-03-03
1A, 2018-03-26 01:00:00.000, 2018-03-05
1A, 2018-03-27 19:00:00.000, 2018-03-03
1A, -, -
1B, 2018-03-25 17:00:00.000, 2018-03-05
1B, -, -
2B, 2018-03-25 17:00:00.000, 2018-03-05
3A, 2018-03-21 22:40:00.000, 2018-03-03
4A, -, -
5A, 2018-03-21 22:40:00.000, 2018-03-09
5A, 2018-03-22 12:00:00.000, 2018-03-11
5A, 2018-03-25 17:00:00.000, 2018-03-05
5A, 2018-03-26 01:00:00.000, 2018-03-05
5A, 2018-03-27 23:00:00.000, 2018-03-05
5A, -, -
5B, 2018-03-26 01:00:00.000, 2018-03-05
5B, -, -
Common, -, -
1, -, -
6, 2018-03-25 17:00:00.000, 2018-03-03
6, 2018-03-25 17:00:00.000, 2018-03-05
6, -, -
];


Final_T:

load Date(min(Start)),Date(Max(Finish)),Pointer
Resident F
group by Pointer;

drop table F;