Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to know is there any way to Find the interval between two dates Which is in Datetime Format to Days,Hrs,mins,secs format?

Hi Guys,

I new to qlikview. i have create a text box which shows the page visited in Webpage, Max(Visited date) and Min(Visit Date). Now I need a help to find out the interval between those two dates and I should show in Days,Hours,Mins and seconds format. Is there any inbild function that we can use. Because i Tried Interval(Date1-Date2) But its show the total Hours format... But what i need is it should be Shown in Days,hrs,mins and secs... Kindly Help me in this... Waiting for your Reply Frnds...

0 Replies