Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
151562
Contributor II
Contributor II

Show budget per month

I need to show the value of the budget in a graph.
I want to show the value of month 1 of the budget in month 1 of production, i.e. when mes=mesbudget.
I'm using the following condition:
if(Mes=MesBudget,
Sum({$<[Hierarchy 4]-={'Accessories','Services'}>}totalBudgetValue))
But it only works when I select both variables in the filter.
How can I show the value and filter only by year?

Thank you,
FPS
Labels (1)
1 Reply
anat
Master
Master

Sum({$<Mes={'MesBudget'},[Hierarchy 4]-={'Accessories','Services'}>}totalBudgetValue)