Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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....
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....