topic Re: sql select lost sign of a field in QlikView

sql select lost sign of a field

rvazquez — Mon, 26 Jan 2026 21:26:37 GMT

Hi!!

I need help, I need to make a sql select throught SQL SAP Connector to a SAP table. In SAP table there are numbers with sign minus, but when I get this values, they are without sign.

For example,

SAP Content:

Qlikview content:

Column Puntos in Qlikview lost the sign.

My SQL Select is:

[ZPUNTOS_CLIENTE]:   // Puntos asignados a un cliente y a nivel de ticket
Load 
   [MANDT] as [ZPUNTOS_CLIENTE.MANDT], 
   [KUNNR] as [ZPUNTOS_CLIENTE.KUNNR], 
   [PUNTOS] as [ZPUNTOS_CLIENTE.PUNTOS], 
   [EUR_JER] as [ZPUNTOS_CLIENTE.EUR_JER], 
   [FECHA] as [ZPUNTOS_CLIENTE.FECHA], 
   [PUNTOS_GASTADOS] as [ZPUNTOS_CLIENTE.PUNTOS_GASTADOS], 
   [TICKET] as [ZPUNTOS_CLIENTE.TICKET]; 
SQL Select MANDT KUNNR TICKET PUNTOS FECHA EUR_JER PUNTOS_GASTADOS  from ZPUNTOS_CLIENTE
;
STORE * FROM [ZPUNTOS_CLIENTE] INTO ZPUNTOS_CLIENTE.QVD;
DROP TABLE [ZPUNTOS_CLIENTE];

Would you know anyone tell me why this error occurs?

Thanks.

Re: sql select lost sign of a field

giakoum — Fri, 15 Mar 2013 14:48:54 GMT

Most likely QV does not recognize the format from SAP. Try to format the number in the select statement (by using to_char?) so that the minus sign goes in front of the number, maybe QV will recognize that easier.

Re: sql select lost sign of a field

rvazquez — Wed, 20 Mar 2013 08:39:10 GMT

Thank you loannis. I tried to format the number in the select statement but when I executed it fails, I don't know what would be the correct sentence.

Otherwise, this field in SAP has set "Flag for sign in numerical fields"

I tried to uncheck this flag and select works perfectly, but I can't do this because program in SAP doesn't work.

Would someone know how can I fix this problem?

Thanks in advance.

Re: sql select lost sign of a field

Wed, 20 Mar 2013 09:03:21 GMT

Hi,

There must be some ABAP code written or transformation done in SAP.

Please check the same from SAP consultant and apply the same in qlikview.

Regards,

Neha Rangari

Re: sql select lost sign of a field

giakoum — Wed, 20 Mar 2013 09:52:49 GMT

did you try something like :

select to_number(to_char(Puntos, '9999.99'), '9999.99') from ZPUNTOS_CLIENTE

Re: sql select lost sign of a field

rvazquez — Mon, 29 Apr 2013 10:58:01 GMT

Hi all,

finally I found the solution, I was using Qlikview Desktop 11.20 and for some reason it ignores minus sign at the end of the number except if I do:

text([PUNTOS_GASTADOS]) as [ZPUNTOS_CLIENTE.PUNTOS_GASTADOS]

then I format this text as:

num#(ZPUNTOS_CLIENTE.PUNTOS_GASTADOS,'#.##0')

finally I sum points correctly.

Thank you all for your help.