Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator
‎2014-10-09 06:31 AM

Simple calculation in Script

Hello,  In my data table I have Start Date and Finish Date. 

How can I add a new dimension - Days to Finish?  (Finish Date-Start Date)

Thanks Paul

240 Views
0 Likes
1 Solution

Accepted Solutions
PrashantSangle
MVP
MVP
‎2014-10-09 06:33 AM

Hi,

Use Interval()

Like

Interval(FinishDate-StartDate,'D hh:mm') as Daysto Finish

for details see in help menu about interval()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

162 Views
0 Likes
2 Replies
bazzaonline
Creator
Creator
‎2014-10-09 06:31 AM
Author

Sorry, I want to create something in the script.

162 Views
0 Likes
PrashantSangle
MVP
MVP
‎2014-10-09 06:33 AM

Hi,

Use Interval()

Like

Interval(FinishDate-StartDate,'D hh:mm') as Daysto Finish

for details see in help menu about interval()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
163 Views
0 Likes