Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Because QlikView has interpreted these as numbers...
Use the Text() function in a preceding Load:
Load Text(a) as a;
SELECT ....
HIC