Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Removing Time Stamp and Calculating Estimated Departure - QlikSense

Hello - I am fairly advanced in QlikView but I have just started using QlikSense, so I am struggling with some of the limitations.

First, I have a date field formatted as:

02/29/2016 10:00AM

I would like to remove the timestamp and just format as MM/DD/YYYY, but nothing I have tried seems to be working.

Also, I have a "Length of Stay" field, which determines the length of a clients trip. I would like to add "Length of Stay" to the date field mentioned above to get an Estimated Date of Departure.

i.e

Date field = 05/05/2016

Length of Stay = 5

Calculated Field, Estimated Date of Departure = 05/10/2016

Thanks in advance,

- dave

10 Replies
Anonymous
Not applicable
Author

Great job Sunny. You just made my day. Thanks very much per usual.