Rename field [2015.000000] to 2015 - Qlik Community

nicholas5141 · ‎2015-11-30

Hi All,

I need help on rename column, currently my column field show [2015.00000] instead of 2015, as the column is based on year so when next year will have 2016 column so I cant rename it manually. I am using load * to display 2010 to 2015 so that when 2016 is added it able to load 2016 as well.

Your help is kindly appreciate thank you.

tamilarasu · ‎2015-12-01

Try,

Num(FieldName)

PrashantSangle · ‎2015-12-01

Hi,

Try Num(Num#(FieldName))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

prma7799 · ‎2015-12-01

please share some sample data.

Mark_Little · ‎2015-12-01

HI,

Could try

Left(F1, 4) AS Name

Or Left(Your Field, 4)

Mark

HirisH_V7 · ‎2015-12-01

Hi ,

Check Out,

PFA

Table:
LOAD
Num(Field) as Year
INLINE [
Field
2015.000000
];


Concatenate


Table2:
LOAD
Field as Year


INLINE [
Field
2013
2014
];

Hope this Helps,

Regards,

HirisH

HirisH
“Aspire to Inspire before we Expire!”

engishfaque · ‎2015-12-01

Dear Nic,

Kindly find attached document, I hope you are looking for that one.

However, please use Floor to remove decimal values such as given below

Floor(ValueField) as newFieldName

Kind regards,

Ishfaque Ahmed

himanshi · ‎2015-12-01

hiii,

it seems like in properties- numbers tab u have used fixed to decimals. check it and try expression default.