Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Might be this is what you required.
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)