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

[sunny_talwar]

Man you are back, didn't we solve something similar couple of month ago? Hahahaha

[#3]

Yes Im back alright

Tried to use our prev solution but I could not get it to work.

Im figuring, using a list of holidays would be more convenient in a sense?

[sunny_talwar]

I guess, I am thinking if I should jump in to look at it or not. I have lot of stuff to work on today and knowing you, your query might not be an easy one .

I will wait and see if someone else chips in, else I will try to help later in the day.

Best,

Sunny

[#5]

Sounds good!

Actually it is the very same query as last time.

In order to calculate some stuff for "todays" date I need some values for the "previous open date".

[#6]

Anyone?

[#7]

Hi Sunindia!

Did you have time to look into the above yet?

I think we I could use the solution u came up with before.

However Im trying to implement it on this data with no luck.

I think it would be a done pretty fast if you had a look

Best regards,

Olle

[sunny_talwar]

Hahahaha, I will definitely spend some time on this today. I will have to revise what I did before and then I might be able to help. I will be leaving for work soon, so will look at this at work.

Best,

Sunny

[#9]

Great, really apopreciate it mate!

//O

[preminqlik]

hi use the below expression for "Previous Total "

=if(rowno()=1,$(=sum({<Date={"$(=Date(min(Date)-1,'DD/MM/YYYY'))"}>}Cat1+Cat2+Cat3)),Above(sum(Cat1+Cat2+Cat3)))

find attachment ,

*Conditions apply - the result is for only one dimension not for multiple dimensions