topic Re: How to Calculate with Month Number in QlikView

How to Calculate with Month Number

Thu, 31 Jul 2014 16:18:27 GMT

Trying to divide Sales thru the end of the last month by the number of months, but I cannot get this to work.

(Sum({$<_YTDAsOfLastMonth={1},Year={$(=Max(Year))}>}[Invoiced Order Net Revenue])) / (Num(Month(vEndOfLastMonth)))

The first half of this formula before the division sign works, but when I try to use a variable to create the month number for the last month, and divide, it doesn't work. I'm sure I'm missing something little, so I'd appreciate any help. Thanks.

Re: How to Calculate with Month Number

Thu, 31 Jul 2014 16:20:52 GMT

Try with this:

(Num(Month($(vEndOfLastMonth))))

Re: How to Calculate with Month Number

Thu, 31 Jul 2014 16:25:58 GMT

Good idea, as I thought about the $ too… I just tried (Sum({$<_YTDAsOfLastMonth={1},Year={$(=Max(Year))}>}[Invoiced Order Net Revenue])) / (Num(Month($(vEndOfLastMonth)))

And it still doesn’t work.

Thanks,

Shelley

Shelley Smith | Manager, Business Intelligence and Analytics

Spacesaver Corporation

DIRECT:: 920.563.0548 | CELL:: 608.751.4295 | TOLL:: 800.492.3434

FAX:: 920.563.0712 | WEB:: www.spacesaver.com

Re: How to Calculate with Month Number

Thu, 31 Jul 2014 16:27:54 GMT

Can you post a sample qvw?

Re: How to Calculate with Month Number

stigchel — Thu, 31 Jul 2014 16:31:06 GMT

The function Month expects a valid Timestamp as parameter, the variable is probably text?

try

Month(Date#('$(vEndOfLastMonth)','YourDateFormat'))