Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
dnowebdn
New Contributor

date isseus

Date issue

1 Reply
Highlighted
shiveshsingh
Honored Contributor

Re: start date and end date

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;