topic Re: COUNTING WITH MONTHS in QlikView

COUNTING WITH MONTHS

Fri, 23 Aug 2013 07:34:27 GMT

Hi All

if Shipdate = 15-01-2013

and I want as result to the monthnumber of the month before

so for the mentioned the result should be 12.

What expression should I use to get this result.

ps.

Num(Date(Shipdate)) wil not work for January as the result is 0

Re: COUNTING WITH MONTHS

MayilVahanan — Fri, 23 Aug 2013 07:41:16 GMT

Try like this

=Num(Month(AddMonths( Shipdate ,-1)))

Hope that helps

Re: COUNTING WITH MONTHS

Fri, 23 Aug 2013 07:43:27 GMT

Works THANXX

Van: Mayil+Vahanan Ramasamy

Verzonden: vrijdag 23 augustus 2013 9:42

Aan: Marc van+Eijk

Onderwerp: Re: - COUNTING WITH MONTHS

<http://community.qlik.com/> QlikCommunity

COUNTING WITH MONTHS

reply from Mayil+Vahanan Ramasamy <http://community.qlik.com/people/MayilVahanan?et=watches.email.thread> in New to QlikView - View the full discussion <http://community.qlik.com/message/381550?et=watches.email.thread#381550>