Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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