topic Re: Return number for Month in QlikView

Return number for Month

stjernvd — Tue, 17 Nov 2015 17:33:45 GMT

Hi,

This script doesn't work, (MaxDate = 30 Aug 2015):

let vMN=Max(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));

I need vMN to = '9' for September...and it's not returning anything at all.

let vM=Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1));

this script returns Sep, so why doesn't the above script work?

sunny_talwar — Tue, 17 Nov 2015 17:36:31 GMT

How are you creating MaxDate??

Max(Date) as MaxDate??

If that is true, try this may be:

LET vMN = Num(Month(AddMonths(Peek('MaxDate'), 1)));

Try this:

LET vMN = Num(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));

maxgro — Tue, 17 Nov 2015 17:45:40 GMT

num or rangemax

let vM=rangemax(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));

Clever_Anjos — Tue, 17 Nov 2015 17:46:15 GMT

There´s no sense to use Max() in this case, because you have only one value returned by Peek