Set Analysis Expression appears to be ignoring dimension in Line graph

[brettlong]

Hello all,

I am a fairly new Qlik Sense user.  I have a line chart with the expression below as the height of line measure.  In addition, I have a dimension of Fiscal_Year.  The expression seems to be ignoring the Fiscal_Year when calculating (the numbers are incorrect and appear to be cumulative in nature).  However, when I filter on a given Fiscal_Year it will yield the correct result for that given Fiscal_Year.  Any help wis appreciated - thanks!

Expression:

=-sum({<[rsch_mon.PI_has_Lab]={1}>} rsch_mon.grant_exp_adj) /
sum(aggr({<[rsch_mon.PI_has_Lab]={1}>} sum([rsch_mon.SquareFootage_GrntLevel]/12),[rsch_mon.PI_ID],[rsch_mon.location],[rsch_mon.grant_id]))

Results (incorrect):

Results when filtered for 2024 (correct)

[brettlong · Accepted solution]

I just realized the error in my ways.  I have fixed the formula for the measure and everything is working now.  Sorry 🙂