topic Re: Min and Max and Set Analysis not functioning in QlikView

Min and Max and Set Analysis not functioning

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

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

Re: Min and Max and Set Analysis not functioning

jduenyas — Mon, 11 Nov 2019 22:52:52 GMT

Posting a question is not as easy as it used to be...

Attempting to attaché the qvw again

Re: Min and Max and Set Analysis not functioning

jduenyas — Mon, 11 Nov 2019 22:56:08 GMT

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!

Re: Min and Max and Set Analysis not functioning

Brett_Bleess — Thu, 14 Nov 2019 14:43:55 GMT

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://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

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