Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Apache
Contributor III
Contributor III

Date issue

Hi all... I just need to get result for this given inline

Load
*
Inline [
Event_Type, Event_Date, Hospital, Department,
A, 2/4/2019, HOSPITAL A, SURGICAL
B, 3/3/2019, HOSPITAL B, ICU
A, 1/10/2019, HOSPITAL C, MEDICAL
B, 3/8/2019, HOSPITAL B, ICU
C, 2/28/2019, HOSPITAL A, OR
C, 1/20/2019, HOSPITAL A, OR
C, 2/15/2019, HOSPITAL A, OR
A, 3/19/2019, HOSPITAL A, ICU
B, 3/18/2019, HOSPITAL B, ORTHO
];

 

I just need the starting date and ending date from the given date and i took both from and end by max and min function now the problem is C is contain 3 dates and the from date is 1/20/2019 and end date is 2/15/2019 but it moves to 2/258/2019 its skipped 2/15/2019... help me on this... thank you

4 Replies
Channa
Specialist III
Specialist III

=date(max(Event_Date),'DD/MM/YYYY')

 

=date(MIN(Event_Date),'DD/MM/YYYY')

Channa
Apache
Contributor III
Contributor III
Author

Hi Channa Thank you...

I had tried this but the date is missing... 

It only displaying the max date and min date 

i just need the 1/20/2019 as from date and 2/15/2019 this as end date 

and too 2/28/2019 as the starting date and today is the end date...

 

Thank you

Channa
Specialist III
Specialist III

please find the attach QVF 

it is showig as you request

Channa
miskinmaz
Creator III
Creator III

Hi,

Please look for interval match topic on community. It will help to generate the today as end date where there is no end date.

Or you can go through the below article:

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/create-dat...