topic Re: Month to Month Number text in QlikView

Month to Month Number text

Fri, 27 May 2016 16:59:26 GMT

Good Morning

As I can convert the month field is numeric and take the value corresponding text

1 - Jan

2 - Feb .. to reach 12 - Dic

But this field is stored in a SQL Server table where only this number between 1 and 12, the display information

It is shown as follows:

but I need to be displayed as follows.

and and tried to MonthName but it does not work, any help is appreciated them.

Re: Month to Month Number text

marcus_sommer — Fri, 27 May 2016 17:27:24 GMT

For monthname() you need a real date-field. Isn't there such a field you could one create with makedate(). But it could be easier simply to map these values with a pick(match()) funtion like:

pick(match(MES, 1,2,3,...), 'Ene', Feb', ...)

- Marcus

Re: Month to Month Number text

Clever_Anjos — Fri, 27 May 2016 17:46:49 GMT

Please try:

=SubField(MonthNames,';',MES)

Re: Month to Month Number text

settu_periasamy — Fri, 27 May 2016 18:05:41 GMT

May be try like this..

=Month(Date#(MES,'M'))

Re: Month to Month Number text

Fri, 27 May 2016 18:18:17 GMT

Thank you very much for the information

Re: Month to Month Number text

Fri, 27 May 2016 18:18:32 GMT

Thank you very much for the information

Re: Month to Month Number text

Fri, 27 May 2016 18:18:43 GMT

Thank you very much for the information

Re: Month to Month Number text

Fri, 27 May 2016 18:19:26 GMT

thank you very much for the information, the three forms serve to perfection.