Format issue on prices

BenjaminCoe1440 — Mon, 13 Feb 2023 08:12:12 GMT

I'm trying to import the following forward prices from an xlsx file that I'm not allowed to edit

but when I import these into Qlik the values are being displayed as dates (tried as dimension and measures), see below.

Can someone please explain why this is happening and how to convert the values from dates into numerical values?

Thanks

Ben

@vinieme12 any ideas??

Re: Format issue on prices

vinieme12 — Mon, 13 Feb 2023 08:40:59 GMT

In the data load editor wrap the fields in Num() function

Example

Tablename:

Load

Elec

, Num([Jan 23]) as [Jan 23]

, Num([Feb 23]) as [Feb 23]

And so on....