Regarding Dates?

[#1]

HI everyone,

I have a small doubt in qlikview

in my month field :the month format is 2015M07 represents July 2007

i want the Month field as July only............

i.e.,

2015M07 to july

2015M06 to june

2015M05 to May

2015M04 to Apr

like that

[ashwanin]

Hi,

Might be this is what you required.

[maxgro]

just replace the '2015M07' with your field Month

=month(makedate(left('2015M07', 4), Right('2015M07', 2)))

you can do it in the script

load

     ....

     month(makedate(left(yourfield, 4), Right(yourfield, 2))) as NewMonth

     ....

or in the user interface (chart)