Change data in a column

[Anonymous]

I have a column called month, the months are being shown as numbers (1,2,3,4,5,6,7,8,9,10,11,12) but I would like the name to be shown (Jan, Feb , sea, apr, may, jun) how do I do this?

Ps: My database is an excel file

Ps: I use the qlik view trial version, I can not open qlik files from other users

Thank you

[rubenmarin]

Hi Nicolas, you can create a date using that month number and get the month from there

=Month(Makedate(Year(Today()),MonthFieldName))

[jobsonkjoseph · Accepted solution]

Hi Nicolas,

Would you try this and see if it works;

map:

Mapping LOAD * INLINE [

    Month1, Month

    1, Jan

    2, Feb

    3, Mar

    4, Apr

    5, May

    6, June

    7, July

    8, Aug

    9, Sep

    10, Oct

    11, Nov

    12, Dec

];

table:

LOAD 

     applymap('map',Month) as Month,

FROM

[..\Downloads\data.xlsx]

(ooxml, embedded labels, table is data);

[Anonymous]

Hello Jobson, the solution worked but I would like to sort the months through the numerical field, is it possible?

[Anonymous]

Hello Ruben, the solution found for this problem is the creation of a map

[jobsonkjoseph]

Hi Nicolas,

I can check on that if sample data can be shared from your end.

[Anonymous]

As dimension I am using Map created, the field Per (Months of numeral form), status and the field "normal" is a sum of values

[jobsonkjoseph]

Dear Nicolas,

You need to use Date#() function in the Sort tab, i'm not able to come up with an expression for it.

Lets see if someone has an idea.

[Anonymous]

Dear Jobson

I'm going to work on this idea!

Thank you

[jobsonkjoseph]

Your welcome Nicolas.

Pls do share the final outcome.