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

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
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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

Labels (1)
Labels
493 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

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

Sorry, I want to create something in the script.

415 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 🙂
416 Views
0 Likes