Expressions not working after migrating to 12.30 from 12.10

[bhsharm5]

Hi,

I have upgraded QlikView server to 12.30 to 12.10 recently. Since the upgrade, lot of expressions have stopped working or are giving wrong numbers. e.g. the below expression which use to give volumes sold the previous day, is now giving volumes for entire year

= ((sum({< Year = {$(vMaxYr)}, Date= {'<=$(=max(Date))' }>}Volume)) - (sum({< Year = {$(vMaxYr)}, Date= {'<=$(=max(Date)-1)' }>}Volume)))/1000

Would appreciate if someone can help.

Regards,

[marcus_sommer · Accepted solution]

Try it with a replace from the single-quotes to double-quotes, like:

... Date= {'<=$(=max(Date))' } ... to ... Date= {"<=$(=max(Date))"} ...

- Marcus

[bhsharm5]

Thanks Marcus. Wonder if I missed it in the release note, or it wasn't made officially public, or if it was part of 12.20 upgrade which I skipped!!! Painfully will now have to go through 50 odd applications checking each and every expression. 

[marcus_sommer]

It's a quite old bug (at least from the early releases of QV 11 but maybe even before) that the set analysis accepted the single-quotes for such numeric comparisons as well as the correct double-quotes. Unfortunately there were various postings here within the community which suggested this wrong way. I remember that there were statements that this will be fixed within one of the next major-release and it was - and it was also announced within the release notes.

I think I would now use the expression-overview to search for those statements and to replace them (be carefully by replacing - I suggest to backup all applications before). Another way to find these expressions could be the use of the document analyzer.

- Marcus