Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
abhinav_rathore
Contributor III
Contributor III

Need Help to calculate "Business Day - Roll to Monday" in QV Expression

Hi All,

Can some one help me to calculate the same logic in Qlikview Expression which Stefan has given correct answer for back-end script in below thread-

"https://community.qlik.com/message/1407913#1407913"

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

Try this

=RangeSum(Above(TOTAL If(If(Len(Trim(Above(TOTAL WEEKEND_OR_HOLIDAY))) = 0, 'NO', Above(TOTAL WEEKEND_OR_HOLIDAY))  = 'YES', 0, 1), 0, RowNo(TOTAL)))


Capture.PNG

View solution in original post

3 Replies
sunny_talwar

Try this

=RangeSum(Above(TOTAL If(If(Len(Trim(Above(TOTAL WEEKEND_OR_HOLIDAY))) = 0, 'NO', Above(TOTAL WEEKEND_OR_HOLIDAY))  = 'YES', 0, 1), 0, RowNo(TOTAL)))


Capture.PNG

View solution in original post

abhinav_rathore
Contributor III
Contributor III
Author

Bro...You are Genius.

Thank you so much for helping me.

sunny_talwar

No problem, glad I was able to help