I'm loading data to Qlik Sense 3.1 from SQL Server. There are some fields defined as decimal in SQL Sever but when I load them from SQL, they appear as text or URL, so I can't show totals for those fields in a chart. I've tried using num() and num#() functions and there's no change.
[Stock] and [Minimo] are defined as decimal(38,20) in SQL, and should be numeric in Qlik Sense
[puntos] and [ObjetivoLiquidar] are defined as varchar(10), but num# function doesn't work and it is also shown as text or URL
This is my data load script for this table:
LOAD ID as ID_LIQ,
Cod as [Articulo ID],
Stock AS [Stock Liquidacion],
Minimo as MinimoLiq,
Num#(Trim(ObjetivoLiquidar)) as ObjetivoLiquidar,
num#(puntos,'#,#') as PuntosLiq;
SQL SELECT ID,
I have tried num() and num#() with all of them and I don't know if I'm missing something or how should I do it. Anyone can help?