Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor III

Month year

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
Contributor III

Re: Month year

Plz find attached app..Hope it helps..

Not applicable

Month year

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
Valued Contributor II

Month year

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

Not applicable

Month year

Hi,

Can you attach your .qvw?

-Jai

Not applicable

Month year

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

Not applicable

Month year

Hi,

   Can you try some Inline Table for that,lik

[Month,Num_Month

Apr,01

May,02

.

.

.

.

]

Like this?

-Jai

Not applicable

Month year

No.No not inline...

Not applicable

Month year

Ok,If possible attach your application

-Jai

Community Browser