11 Replies Latest reply: Jul 14, 2018 6:41 AM by Steve Br. RSS

    Set Analysis Problem with QS June 2018

    Steve Br.

      Hi,

       

      I have a problem that occurred after I upgraded to QS June 2018.

       

      My Data is like:

       

      Document,Number

      100,1

      200,2

      300,3

      400,

      500,5

      600,6

      700,

      800,8

      900,9

       

      With QS February 2018 the expression Count({<Number-={'9'}>}Document) would return 8. Yesterday I upgraded to June 2018 and reloaded the data (I did not make any change in the data file or the app). Now the same expression returns 6, i.e. totally ignoring the lines with no Number value as if they do not exist. If I change the script to IF(LEN(TRIM(Number))=0, 'Missing', Number) AS Number

      then the expression returns 8 again.

       

      Also, with the previous release, the expression Count({<Number={''}>}Document) would return 2. With QS June 2018 it returns 0 and works again only after the change in the script mentioned above.

       

      Is this a bug in this version or what is going on?