outstanding months have no values when selecting additional criteria

Thu, 21 Oct 2010 09:22:08 GMT

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

outstanding months have no values when selecting additional criteria

Thu, 21 Oct 2010 09:32:02 GMT

Oh man i just found the mistake in the script

sorry

topic outstanding months have no values when selecting additional criteria in QlikView

outstanding months have no values when selecting additional criteria

outstanding months have no values when selecting additional criteria