topic Re: Month-Year from Date in QlikView

Month-Year from Date

Wed, 28 May 2014 10:15:06 GMT

Hi, I have a field OrderDate field, By this i have created the year, moth, Week

in this month i get 1 to 12 as a integer value

But i want YearMonth in

YearMonth

************

Jan-2012

Feb-2012.... and so on

how i can get this.

Please help me

Re: Month-Year from Date

Anonymous — Wed, 28 May 2014 10:16:32 GMT

Try using the MonthName() function.

Re: Month-Year from Date

senpradip007 — Wed, 28 May 2014 10:19:26 GMT

Use this

MonthName([Calendar Date]) .

[Calendar Date] should be in "YYYY/MM/DD" format.

Re: Month-Year from Date

sasikanth — Wed, 28 May 2014 10:21:15 GMT

Set the Date formt to 3-JAN-2012 like this

and then use MID(3-JAN-2012,3,10) --- gives JAN-2013

Re: Month-Year from Date

Wed, 28 May 2014 10:22:28 GMT

Thank you so much i works.

If i need MonthYear in the format

MonthYear

***********

Jan-12

Feb-12

How can i get. please tell me

Re: Month-Year from Date

Anonymous — Wed, 28 May 2014 10:24:19 GMT

date ( MonthName ( [YourDate] ) , 'MMM-YY' )

Re: Month-Year from Date

hic — Wed, 28 May 2014 10:25:14 GMT

The best way (in my mind) is to use

Date(MonthStart(OrderDate), 'MMM-YY') as YearMonth

HIC

Re: Month-Year from Date

senpradip007 — Wed, 28 May 2014 10:25:49 GMT

Try this

Date([Date Field], 'MMM-YY')

Re: Month-Year from Date

Wed, 28 May 2014 10:38:37 GMT

Thank you Mr.Henric Crostrom.

I got the answer.

Re: Month-Year from Date

its_anandrjs — Wed, 28 May 2014 10:43:52 GMT

You also try this way also

Date(MonthName(OrderDate), 'MMM-YY') as YearMonth

Re: Month-Year from Date

Thu, 29 May 2014 08:29:17 GMT

Thank You Anand.. i try it also it's Working.