topic Re: calculate expression in QlikView

calculate expression

Anonymous — Mon, 28 Sep 2015 10:38:13 GMT

I have initially this expression

=if(IsNull(GetFieldSelections(Week,'*')),Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC]),Sum({$<Weekyear= {$(=max(Weekyear))}>}[Prix de vente TTC]))

I need to add to this expression the sum [budget] from today till the end of the year

How to do it ?

Re: calculate expression

Peter_Cammaert — Mon, 28 Sep 2015 10:41:06 GMT

Budgets are usually provided per month. How do you want to split the current month's budget from the current date onwards? Based on remaining working days? Based on remaining calendar days? No splitting at all?

Peter

Re: calculate expression

Anonymous — Mon, 28 Sep 2015 10:44:11 GMT

No splitting at all.

Re: calculate expression

Peter_Cammaert — Mon, 28 Sep 2015 11:14:04 GMT

Something like this (add to the existing expression)?

+ Sum({<Year = {"$(=Year(Today()))"}, Month = {">=$(=Month(Today()))"}>} [Budget])

I did follow your question as stated, but this seems pretty useless to me as you'll be mixing a budget from today onwards with Actuals that possibly belong to a previous year. Is that you intention?