Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Set Analysis hard code and dimension

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 YrEnd YrACT_QTRACT($)
201820221604$4,600,000.00
201820221802$2,677,500.00

 

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

Start YrEnd YrACT($)
20182022$2,677,500.00

 

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

Start YrEnd YrACT($)
20182022$7,277,500.00

 

Thanks

Steve

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand