topic Issue with previous month and date formatting and math in QlikView

Issue with previous month and date formatting and math

Thu, 26 Aug 2010 22:24:34 GMT

Any idea why the following occurs?

Expression1 (works):

Sum({$<[Time.Month ID] ={$(=Date(Max([Order.Receive Date]), 'YYYYMM'))}>} [Order.Request Value]) --returns 201008

Expression 2 (doesn't work: trying to figure out sntax to return 201007):

Sum({$<[Time.Month ID] ={$(=Date(Max([Order.Receive Date]), 'YYYYMM')-1)}>} [Order.Request Value]) -returns 40394

Any help would be appreciated!

Thanks,

Dan

spsrk_84 — Fri, 27 Aug 2010 07:33:24 GMT

Hi,

I tried in another way to get the required o/p

Date(AddMonths((TODAY()),0),'YYYYMM') IT returns 201008

Date(AddMonths((TODAY()),-1),'YYYYMM') It RETURNS 201007

I think u need to implement the same sort of logic to get the desired output in your case..

Check in this way Hope it works...........

Cheers

Ajay