outstanding months have no values when selecting additional criteria

[#1]

Once again I have to rely on you smart guys here,

I have set up a table with our actual sales, budget and previous year (=columns), the rows are the twelve months

For budget figures I load an excel sheet where the amounts are entered on business unit level.

Thats works fine, when I have no selections made there are actual sales (2010) from january to september and budget amounts are there for january to dezember (as it should be).

But when i select one Business Unit, the outstanding months (october, november, december) have no values (in budget column). The generel logic is working, so I get the fitting budget amounts for the choosen business unit for all months except the outstanding.

code for budget column is:

=

sum({$ < Year= {$(=year(MaxOrderDate))}, CostumerType={Third} > } BudgetAmount

)

I would understand what he is doing if I had coded it with inYearToDate function but i just tell him the year and the costumer type so i cant follow Qlikviews logic 😞

I am so close to get my first complex Qlikview analysis finished 😞

Hope you can help me guys, thanks a lot in advance for your effort!

Regards,

Christoph

[#2 · Accepted solution]

Oh man i just found the mistake in the script

sorry