Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bhsharm5
Contributor III
Contributor III

Expressions not working after migrating to 12.30 from 12.10

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,

 

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

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

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

- Marcus

View solution in original post

3 Replies
marcus_sommer

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

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

- Marcus

bhsharm5
Contributor III
Contributor III
Author

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