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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
1 Solution

Accepted Solutions
rbecher
Partner - Master III
Partner - Master III

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
Partner - Master III
Partner - Master III

Probably:

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

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