topic MonthName +1 not working in QlikView

MonthName +1 not working

Wed, 10 Nov 2010 08:31:01 GMT

Hi ,

I am trying to display a monthname in the label.

If i select jan then the label should appear Feb

I have tried MonthName+1 ,but no luck

How to get this done ?

Thanks,

Srihari

MonthName +1 not working

deepakk — Wed, 10 Nov 2010 08:46:53 GMT

First Convert the Month Name data to Yearmonth i.e in Number format (Make it at script level) ..

e.g : 201009

then use the below expression

monthname(date#(Yearmonth-1,'YYYYMM'))

MonthName +1 not working

Wed, 10 Nov 2010 10:29:52 GMT

Hi Deepak,

I have changed the format as you suggested.

YearMonth on selecting Nov from the MonthName field is 2010-11.

=(date#(([Yearmonth]),'YYYYMM')) is giving 2010-11. This looks fine.

=MonthName(date#(([Yearmonth]),'YYYYMM')) is not working. I am getting a null value.

=(date#(([Yearmonth]+1),'YYYYMM')) is giving 2022

=(date#(([Yearmonth]-1),'YYYYMM')) is giving 2020. Don't get this weird behavior.

Any suggestions

Srihari

MonthName +1 not working

deepakk — Wed, 10 Nov 2010 10:53:29 GMT

Dont put a "-' in between. It should be 201011 for 2010-Nov

MonthName +1 not working

Wed, 10 Nov 2010 11:25:49 GMT

Even tried that ..The result is same...

MonthName +1 not working

deepakk — Wed, 10 Nov 2010 11:49:10 GMT

I think you data is this format

20101 ---- 2010-Jan

20102 -- 2010- feb

......

201010 ---2010- Oct

201011 --- 2010 - Nov

if it is you need convert you month to two digits....

Else send you application we can check it out....

I have implemented this many time. so it should work.

MonthName +1 not working

Anonymous — Thu, 26 Jan 2012 10:29:57 GMT

Hi Srihari,

Have you tried using:

addmonths( MonthName, 1)

You can then wrap it in a date function to achieve any formatting, e.g.:

date( addmonths( MonthName, 1), 'YYYY MMM')

Regards,

Dilyana