Set Analysis Expression appears to be ignoring dimension in Line graph

brettlong — Tue, 11 Mar 2025 20:28:36 GMT

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)

Re: Set Analysis Expression appears to be ignoring dimension in Line graph

brettlong — Tue, 11 Mar 2025 20:34:40 GMT

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

topic Set Analysis Expression appears to be ignoring dimension in Line graph in App Development

Set Analysis Expression appears to be ignoring dimension in Line graph

Re: Set Analysis Expression appears to be ignoring dimension in Line graph