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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

round up the difference vales between two dates ??

Hi,

Can anyone please help me in rounding up the difference values between two dates.

please  find the attached QVW which has my requirement

1 Solution

Accepted Solutions
rbecher
MVP
MVP

Probably:

if(diff > 1, ceil(diff), floor(diff))

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

View solution in original post

1 Reply
rbecher
MVP
MVP

Probably:

if(diff > 1, ceil(diff), floor(diff))

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine