topic Re: Set analyses with masteritem vBudget in QlikView

Set analyses with masteritem vBudget

Marcellino_Groothof — Thu, 14 Sep 2017 09:20:09 GMT

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 — Thu, 14 Sep 2017 09:22:30 GMT

May be this?

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

Marcellino_Groothof — Thu, 14 Sep 2017 09:25:00 GMT

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

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:28:06 GMT

This?

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

Marcellino_Groothof — Thu, 14 Sep 2017 09:29:52 GMT

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

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:36:21 GMT

It works but it sums the double

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

jayshrinipurte — Thu, 14 Sep 2017 10:30:21 GMT

Hi Marcellino....

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

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

Regards,

Jayshri

Marcellino_Groothof — Thu, 14 Sep 2017 13:00:10 GMT

Thanks Jayshri,

The following expression I have used now:

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

Regards,

Marcellino

jayshrinipurte — Thu, 14 Sep 2017 13:05:21 GMT

Welcome Marcellino....