Autocomplete Left Zero

[leonardo_sudo]

Hi,

When I execute this script,  (without EMS5MOV.PUB."tit_acr"."cod_espec_docto" = 'CC' )

tit_acr:
SQL   SELECT *
FROM  EMS5MOV.PUB."tit_acr"
where EMS5MOV.PUB."tit_acr"."dat_transacao" >= '$(DataTransacao)'
  and EMS5MOV.PUB."tit_acr"."cod_tit_acr" = '233'
  //and EMS5MOV.PUB."tit_acr"."cod_espec_docto" = 'CC'  
with (nolock);
STORE tit_acr into [lib://Dados/Extraidos/teste/tit_acr.qvd](qvd);
DROP Table tit_acr;

The result is:

Eg. Look to 6. Collumn, Line 2

But, when a I execute: (with EMS5MOV.PUB."tit_acr"."cod_espec_docto" = 'CC' )

tit_acr:
SQL   SELECT *
FROM  EMS5MOV.PUB."tit_acr"
where EMS5MOV.PUB."tit_acr"."dat_transacao" >= '$(DataTransacao)'
  and EMS5MOV.PUB."tit_acr"."cod_tit_acr" = '233'
  and EMS5MOV.PUB."tit_acr"."cod_espec_docto" = 'CC'  
with (nolock);
STORE tit_acr into [lib://Dados/Extraidos/teste/tit_acr.qvd](qvd);
DROP Table tit_acr;

The result is:

Same line, but QLIK autocomplete with left zero.

I know it's "AI", but how to disable it? I do not want to use function, because it wants my true data.

Thanks

[Marcos_rv]

try this:

tit_acr:

//load precedente

LOAD 

FIELD1,

FIELD2,

FIELDN,

.....

TEXT(cod_parcela) AS cod_parcela;

SQL SELECT *
FROM EMS5MOV.PUB."tit_acr"
where EMS5MOV.PUB."tit_acr"."dat_transacao" >= '$(DataTransacao)'
and EMS5MOV.PUB."tit_acr"."cod_tit_acr" = '233'
and EMS5MOV.PUB."tit_acr"."cod_espec_docto" = 'CC'
with (nolock);
STORE tit_acr into [lib://Dados (integrada_setec)/Extraidos/teste/tit_acr.qvd](qvd);
DROP Table tit_acr;

[leonardo_sudo]

Hi, i think this ok,
But i just want my real data. Without functions.