topic Re: Set Analysis help with >=<= in QlikView

Set Analysis help with >=<=

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

Hi all,

I can't get the following expression to work, can anyone see what i am doing wrong in the red text? The expression works without the red text included.

Count({<isActive={'true'},MAX(num([Store Audit Date]))={'>=$(=num(YearMonth)) <=$(=num(MonthEnd(YearMonth)))'}, $(vSet_ExcludedTime), $(vSet_ExcludedProduct) >} _%Account)

Re: Set Analysis help with >=<=

pepecc — Mon, 29 Jul 2019 16:38:34 GMT

Maybe my answer is useless, but I would use " (double quotes) instead of ' (simple quote) to close the expression

Re: Set Analysis help with >=<=

hopkinsc — Tue, 30 Jul 2019 07:13:53 GMT

Hi, thanks for your reply, unfortunately it doesn't help 🙂 I think the quotes are correct, i am getting a syntax error from the first curly bracket...

Re: Set Analysis help with >=<=

pepecc — Tue, 30 Jul 2019 07:25:14 GMT

Maybe it is because you need a field on the left of the =. I have never used an expression on the left side of the = in set analysis. I think it needs to be a field, not an expression. I am pretty sure that this expression: MAX(num([Store Audit Date])) is not valid for the left side of = in set analysis. You need a field.

Re: Set Analysis help with >=<=

hopkinsc — Tue, 30 Jul 2019 07:25:55 GMT

I think it might be that i am using MAX within the set analysis, can anyone confirm please? and if that's the reason, does anyone know how i can use the MAX(Date) within the set analysis?

Re: Set Analysis help with >=<=

pepecc — Tue, 30 Jul 2019 07:28:55 GMT

See this:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Variables-in-Set-Analysis-Left-side-of/m-p/103663

Here they say that you can not use expressions on the left side of = in set analysis. Just fields

Re: Set Analysis help with >=<=

miskinmaz — Tue, 30 Jul 2019 07:29:48 GMT

You need to use a field at the left side of the expr like:

Count({<isActive={'true'},someField={"=$(MAX(num([Store Audit Date]))={'>=$(=num(YearMonth)) <=$(=num(MonthEnd(YearMonth)))'})"}, $(vSet_ExcludedTime), $(vSet_ExcludedProduct) >} _%Account)

Re: Set Analysis help with >=<=

hopkinsc — Tue, 30 Jul 2019 07:35:07 GMT

Thanks, although i am using the field, but the field has aggregation around it as i only want to use the MAX of the field.

I think it will be easier for me to create the MAX(NUM(Date)) in the script and use the resulting field instead.

Thanks

Re: Set Analysis help with >=<=

Brett_Bleess — Wed, 21 Aug 2019 14:00:41 GMT

Just wanted to toss in some other links that may be of some help on this one to others:

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/A-Primer-on-Set-Analysis/ba-p/1468344

The latter has additional post links at the bottom of the post...

Regards,
Brett