Discussion Board for collaboration on QlikView Scripting.
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.
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.
Plz find attached app..Hope it helps..
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.
u create a field num(Month) &' 'year
Can you attach your .qvw?
Month field is having values as Apr,May,Jun...therefore it can't me converted into Num...as it is a text.
Can you try some Inline Table for that,lik
No.No not inline...
Ok,If possible attach your application