Decimal in db, gets Null in Qlik

[#1]

In our databse we read a row column called: Penalty as a decimal(19,6), I have rows in the database but in qlikview I get Null values on this column in every row. What can be the issue for this?

[Anonymous]

Hi Niklas,

Use Num# and Num,

Num(Num#(YourField, DatabaseFormat),'QVFormat)

Regards!