topic Month year in QlikView

Month year

Fri, 10 Jun 2011 04:29:51 GMT

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.

Month year

deepakk — Fri, 10 Jun 2011 05:23:05 GMT

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

Re: Month year

rahulgupta — Fri, 10 Jun 2011 05:26:16 GMT

Plz find attached app..Hope it helps..

Month year

Fri, 10 Jun 2011 05:40:21 GMT

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.

Month year

perumal_41 — Fri, 10 Jun 2011 05:59:03 GMT

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

Month year

Fri, 10 Jun 2011 06:00:03 GMT

Hi,

Can you attach your .qvw?

-Jai

Month year

Fri, 10 Jun 2011 06:46:43 GMT

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

Month year

Fri, 10 Jun 2011 06:50:31 GMT

Hi,

Can you try some Inline Table for that,lik

[Month,Num_Month

Apr,01

May,02

]

Like this?

-Jai

Month year

Fri, 10 Jun 2011 07:12:59 GMT

No.No not inline...

Month year

Fri, 10 Jun 2011 07:16:45 GMT

Ok,If possible attach your application

-Jai

Month year

Fri, 10 Jun 2011 07:22:21 GMT

I can't attch my app...its too heavy...

in small dataset u won't be able to understand the thing....

neither can i prepare a dummy data....it will take a lot of Time...

Re: Month year

Fri, 10 Jun 2011 07:33:10 GMT

Here I have a calendar which has some fiscal fields maybe you can use. I use the addmonths function, and also a sort of load order, using the table at the top which is later concatenated into the main calendar table

How do i add a file - I can't find the option !

ok got it!

Month year

deepakk — Fri, 10 Jun 2011 09:22:24 GMT

hi Erika,

Try this for converting textb APR into num.

date(Date#('APR','MMM'),'MM')

Deepak

Re: Month year

Fri, 10 Jun 2011 11:59:33 GMT

Hi Erika,

There are many ways to do that...Two simple ways I can suggest you are...

in your environment variable settings you can use this...but be cautious this will reflect through whole document....so now your months sort order will be changed to this way and your 1st month will be april..

SET MonthNames = 'Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar';

2. Another way I find will be better, is just use shift in monthname function..

for example if you use monthname function like:::

monthname ( '2001-01-19' ) it will output Jan 2001

but if you use shift here and shift monthnames to 3 then ...

monthname ( '2001-01-19' ,3) it will output Apr 2001

as you only have month and year then you can use it like monthname(makedate(Year, Month),3) it can give you your output......

so, in 2nd one you will be having data of MonthNum 1 associated with Month Apr, that way in your front end when some one selects Apr, he will see data for MonthNum 1, and also it can be sorted on the base of MonthNum..........

hope it helps..

and if I did not understand your problem then, if you describe it more, like what you actually want then we may reach towards a better solution.......

Re: Month year

Fri, 10 Jun 2011 12:41:00 GMT

Hi,

The number 1 equals April, so add more 3 and you have the month that you want.

Load Year, // 2011

(Month + 3 ) AS Month // Month = 1 = April

// Month + 3 = 4 = April

...