Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

Calculation Error

Hi All

I am doing Calculation of Numbers based on Logic.

The Correct Calculation are Green in Color and Wrong Calculation is Red in Color.

I am calculation Time Difference between CreationTime & OutTime based on:

1. The Creation Time & End Time should be considered between StartTime & EndTime.

2. Eg. 1268170, 1274294, 1300082, 1435122 - Consider only Mon-Fri and exclude Saturday & Sunday.

I have implemented logic of Weekdays in the Logic.

Script_1.png

Kindly, see the Attachment.

Regards

Av7eN


10 Replies
aveeeeeee7en
Specialist III
Specialist III
Author

Hi Juan

1 case is causing problem.

Could be please suggest what's going wrong???

In Attached Qvw, Red Colored Case is causing problem

Regards

Av7eN