Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

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

1 Reply
Employee
Employee

Re: How can I stop QlikView eating my strings?

Because QlikView has interpreted these as numbers...

Use the Text() function in a preceding Load:

Load Text(a) as a;

SELECT ....

HIC