topic Re: Autocomplete Left Zero in App Development

Autocomplete Left Zero

leonardo_sudo — Tue, 07 May 2019 20:51:14 GMT

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

Re: Autocomplete Left Zero

Marcos_rv — Tue, 07 May 2019 20:55:50 GMT

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;

Re: Autocomplete Left Zero

leonardo_sudo — Tue, 07 May 2019 21:02:12 GMT

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