Discussion Board for collaboration related to QlikView App Development.
MAX(Aggr( Sum({<YR=, MonthYear=, MonthYear={">=$(=MonthName(=YearStart(Today(),-1)))<=$(=MonthName(=YearEnd(Today(),-1)))"}>} Orders ) , MonthYear)
The Set Modifier YR=, and MonthYear=, do not block the effects of date selection on the final result in the expression.
Does anyone have any input regarding this issue?
(sample qvw is attached)
Thanks
Josh
Posting a question is not as easy as it used to be...
Attempting to attaché the qvw again
I apologize.
Nothing is working as it used to... Still not able to attach a sample qvw. First half of my original question was erased and discarded.
I have no idea what is going on.
I am giving up!
Hey Josh, sorry for the troubles you had, dropping some URLs here that may help you work through things to be sure you have correct syntax etc.
https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Sorry I do not have something better for you, I am pretty bad with set analysis, but hopefully the link may allow you to double-check your syntax at least to be sure that is not the problem. My post will also kick things back up, so someone else may have a look, I do see you attachment, so hopefully someone that knows more than I do on this may be able to have a look and leave you another post.
Cheers,
Brett