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

[MarcoWedel]

Hi,

when loading your months as proper dual values you don't have to care about sorting issues as the default numerical search will be correct.

One way to do so would be to load

Month(Date#(month,'M')) as month

hope this helps

regards

Marco

[Anonymous]

Hello Marco, I did not understand how! I tried opening your Qlik file but I use the personal version.

Sorry, I am a beginner in Qlik and I have very limited knowledge

Regards

Nicolas

[rubenmarin]

Hi Nicolas, in the sorting tab you can use the Month field in number to sort the dimension. This can solve your issue using the mapping table.

Also, the use of Month() function to create the field can help, using that function months can be shown as text but sorted by num. Marco posts how you can use this function:

table:

LOAD

  Month(Date#(month,'M')) as month

Note that having a dedicated field for month in number can help with some expression so it's not a bad idea to keep formats separated: one for selections other for internal expressions, but in most situations a unique month field created as a dual value can do the work.

[Anonymous]

Hello Rubin, I'll check your solution.

I'm running some other tests but then sent you some feedback.

Thank you for your help

greetings

Nicolas

[Anonymous]

Hi Jobson,

I found the solution to the problem, I used the Dual function, below

Mapping LOAD * Inline [

Num, Month

1, Jan,

2, Feb,

3, Mar,

4, Apr,

5, May,

6, Jun,

7, Jul,

8, Aug,

9, Sep,

10, Oct,

11, Nov,

12, Dec

];

TestTable:

LOAD

*,

Dual (ApplyMap ('Map_MES', Per), Per) AS [Month]

From [archive]

regards

Nicolas