Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

outstanding months have no values when selecting additional criteria

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





1 Solution

Accepted Solutions
Not applicable
Author

Oh man i just found the mistake in the script

sorry

View solution in original post

1 Reply
Not applicable
Author

Oh man i just found the mistake in the script

sorry