Set Analysis hard code and dimension

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

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

Re: Set Analysis hard code and dimension

Gysbert_Wassenaar — Mon, 10 Dec 2018 07:52:53 GMT

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

topic Set Analysis hard code and dimension in QlikView

Set Analysis hard code and dimension

Re: Set Analysis hard code and dimension