1 Reply Latest reply: Jun 13, 2013 5:53 AM by Henric Cronström RSS

    How can I stop QlikView eating my strings?

      Hi,

       

      if I put the following in the script:

       

      test:

      SQL

      SELECT '000' a FROM DUAL UNION ALL

      SELECT '0D1' a FROM DUAL UNION ALL

      SELECT '0D2' a FROM DUAL UNION ALL

      SELECT '0D3' a FROM DUAL UNION ALL

      SELECT '0D4' a FROM DUAL UNION ALL

      SELECT '0E1' a FROM DUAL UNION ALL

      SELECT '0E2' a FROM DUAL UNION ALL

      SELECT '0G3' a FROM DUAL;

       

      A listbox showing the value of the "a" fied list the following values:

      000

      0G3

       

      Why the values 0D1..0D4, 0E1, 0E2 have disappeared and why 0G3 has not? What can I do to fix the problem in my reports?

      Please note that the problema happen with every query that returns similar results.

       

      I am using the "11.20.11922.0 SR2" version if this is of any help.

       

      Regards,

       

      Michele Artoni