topic Set Analysis to Consider Current Field Selections in QlikView

Set Analysis to Consider Current Field Selections

triekong — Wed, 25 Nov 2020 16:16:04 GMT

i want to find the Year to date Actuals for only if my Org Level 3 = Geo Services.

my analysis formula that says:

=Sum({<FYear={$(vMax_Year)}, fMonth=,[Org Level 3]={'Geo Services'}>}[Actuals])

now when i select another value in that same Org Level 3 field, my result stays the same, while i want it to go to "0".

how do i say, i only want a result, if the Org Level = "Geo Services". so that if the user selects Org Level 3= Finance, my answer goes to 0.

should i use a SUMIF instead, or is this possible with set analysis.

trdandamudi — Fri, 21 Sep 2018 18:21:12 GMT

Give a try on the below:

=If(GetFieldSelections([Org Level 3])='Geo Services',Sum({<FYear={$(vMax_Year)}, fMonth=,[Org Level 3]={'Geo Services'}>}[Actuals]),0)

vamsee — Fri, 21 Sep 2018 19:21:52 GMT

Try adding an asterisk like below

Sum({<FYear={$(vMax_Year)}, fMonth=,[Org Level 3]*={'Geo Services'}>}[Actuals])