topic Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4 in QlikView

Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

qlik_Maestro — Sat, 16 Nov 2024 19:10:54 GMT

Hello All,

In an effort to upgrade from 11.2 SR7 to the latest 12.4 we are seeing a discrepancy in the way certain set analysis expressions are executed. The expression below works perfectly in 11.2 but gives null in 12.4. We have tried to break down each part of the expression to its individual parts and they seem to be evaluating identically up until the point where they are put together.

Any ideas what changed in the newest version so that we can better identify places we need to make changes? We thought it could be something to do with the way the 12.4 handles quotations differently but that is not the reason for this particular example. I also couldn't find release notes about this. Any help would be much appreciated!

=Max({$<[SourceDate_1] = {'<=$(=Monthend(AddMonths(GetFieldSelections([SourceDate_2]),-1)))'}>} [SourceDate_1])

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

sunny_talwar — Tue, 04 Feb 2020 14:25:30 GMT

Try replacing single quotes with double quotes and see if that works (Quotes in Set-Analysis)

=Max({$<[SourceDate_1] = {"<=$(=Monthend(AddMonths(GetFieldSelections([SourceDate_2]),-1)))"}>} [SourceDate_1])

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

qlik_Maestro — Tue, 04 Feb 2020 15:08:16 GMT

The quotes are not the problem here. Even if I do that or use the backwards compatibility script it is still null in v12.4

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

sunny_talwar — Tue, 04 Feb 2020 16:37:26 GMT

Try this

=Max({$<[SourceDate_1] = {"<=$(=Date(Floor(MonthEnd(Max([SourceDate_2]), -1))))"}>} [SourceDate_1])

or this

=Max({$<[SourceDate_1] = {"<=$(=Date(Floor(MonthEnd(Max([SourceDate_2]), -1)), 'SpecifyDateFieldFormatHere'))"}>} [SourceDate_1])

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

qlik_Maestro — Tue, 04 Feb 2020 19:01:46 GMT

While the second one was the solution to the issue, does anyone know the underlying reason behind this? Is there a change in the behavior of dates with the newest version? It did seem like there was when we investigated some of our QVDs the formatting had changed.

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

sunny_talwar — Tue, 04 Feb 2020 19:54:00 GMT

Did you change the environmental variables within the qvd generators? @hic might be able to answer this better

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

qlik_Maestro — Tue, 11 Feb 2020 19:43:31 GMT

There were no changes made between the qvd generators.

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

sunny_talwar — Wed, 12 Feb 2020 12:46:18 GMT

In that case, I am not really sure.

Re: Set Analysis Evaluation Discrepancy between verision 11.2 and 12.4

Brett_Bleess — Tue, 03 Mar 2020 22:41:29 GMT

Should be related to the following Design Blog post I believe, quote changes... I am not sure if I missed something else or not, but things were tightened up in Set Analysis a lot from where you were to where you moved... This is why you wan to be sure to read the Release Notes docs for each interim major point release you jump to get the changes between releases...

https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824

Regards,
Brett