Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month year

Hi guys I have a small problem...

I have year and Month No.

If Year is 2011 and Month is 1 thn it means its April 2011.

I want to create month year thru func.Monthname.

14 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi Erika,

Do the following  steps.

1) go to Script -- and change the Month name format. Currently it begins with Jan;Feb;Mar;... change it to pr;Jun;Jul.....Feb;Mar;

2) Create Date using Makedate function and use the Monthname function on it.

MonthName(MakeDate(Year,Month)) as MonthName.

I hope this helps.

Deepak

rahulgupta
Partner - Creator III
Partner - Creator III

Plz find attached app..Hope it helps..

Not applicable
Author

Thanks for reply....

but I don't want this...

I can't use monthname.

i have created a field Month &'  'year

Now I want it to convert into numeric  because I need to sort something on its basis.

perumal_41
Partner - Specialist II
Partner - Specialist II

u create a field num(Month) &'  'year

Not applicable
Author

Hi,

Can you attach your .qvw?

-Jai

Not applicable
Author

Month field is having values as Apr,May,Jun...therefore it can't me converted into Num...as it is a text.

Not applicable
Author

Hi,

   Can you try some Inline Table for that,lik

[Month,Num_Month

Apr,01

May,02

.

.

.

.

]

Like this?

-Jai

Not applicable
Author

No.No not inline...

Not applicable
Author

Ok,If possible attach your application

-Jai