Set analyses with masteritem vBudget

[Marcellino_Groothof]

What is the right syntax with set analyses when year=2017 and I want to use the masteritem vBudget?

masteritem in script is: vBudget = sum(Budget)

[Anil_Babu_Samineni]

May be this?

Sum({<Year = {2017}>} Budget)

[Marcellino_Groothof]

I want to use the masteritem vBudget within the set analyses (QlikView)

[Anil_Babu_Samineni]

This?

Sum({<Year = {2017}, masteritem = {$(vBudget)}>} Budget)

[Marcellino_Groothof]

=for example: sum({$<Jaar={'2012'}>} $(vBudget)) but this doesn't work (2 sums)

[Anil_Babu_Samineni]

It works but it sums the double

sum({$<Jaar={'2012'}>} Aggr($(vBudget), YourDimensions))

[jayshrinipurte · Accepted solution]

Hi Marcellino....

vBudget= Sum({<Year = '2017'>} Budget)

wherever you need this expression, use this variable as "$(vBudget)"

Regards,

Jayshri

[Marcellino_Groothof]

Thanks Jayshri,

The following expression I have used now:

Sum({$<SalesPerson={"=$(vBudget)>355000"}>}Budget)

Regards,

Marcellino

[jayshrinipurte]

Welcome  Marcellino....