Set Analysis hard code and dimension

[steve1982]

Hi,

I am tried get the Act ($) by filter Start Yr between End Yr. I am using the hard code which Start Yr >2018, it able to get the correct result. But if I am replace the 2018 with Start Yr is show wrong result. Please advise any issue on the expression.  Also how I am able to get the ACT($) between Start Yr and End Yr.

Raw Data

Start Yr	End Yr	ACT_QTR	ACT($)
2018	2022	1604	$4,600,000.00
2018	2022	1802	$2,677,500.00

Correct Result using 2018 (SUM({<$(vMQACTSet),ACT_YEAR={">=2018"}>}$(vMQACTField)))

Start Yr	End Yr	ACT($)
2018	2022	$2,677,500.00

Replace 2018 using Start Yr- Wrong result SUM({<$(vMQACTSet),ACT_YEAR={">=$([Start Yr])"}>}$(vMQACTField))

Start Yr	End Yr	ACT($)
2018	2022	$7,277,500.00

Thanks

Steve

[Gysbert_Wassenaar]

If you're using Qlikview you can look at the qvw attached here to see what your problem is: https://community.qlik.com/t5/QlikView-Documents/set-analysis-intra-record-qvw/ta-p/1479689