Sum prev date. Ignore holidays and weekends

[#1]

Hi,

I need to sum data from the prev open date.

Problems occur when:

1. Holidays.

2. When I select a month, the very last sum from the prev month will not show.

In my table I've now added the holidays, but Im not sure how to implement in qlikView.

Pls find attached example QV-file

Expected result as per below when choosing january.

Regards,

Olle

[#2]

Hi Prem,

thanks for your answer.

Problem is, for the dates with Today Total <>0 I always need a Previous Total <>0.

In other words, for instance if it's a monday, then previous total for this date should be fridays total.

However, it gets even more complicated when there is sometimes a weekend plus a few holidays inbetween the dates.

For instance, if thur and fri is a holiday, then next monday value for previous total should be the sum from wednesday the week before.

Thanks in advance,

Olle

[sunny_talwar]

Nobody has looked at it still? Would you be able to send me the file from our very last post and explain me what exactly you are trying to do differently this time in an email? I will send a private message to give you my id.

Best,

Sunny