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

[Anonymous]

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

[sunny_talwar · Accepted solution]

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)))

[Anonymous]

Bro...You are Genius.

Thank you so much for helping me.

[sunny_talwar]

No problem, glad I was able to help