Newbie needs help with Month To Date

Wed, 27 Feb 2013 14:07:45 GMT

Hi,

I'm an absolute newbie at this and about to make a complete fool of myself I expect but...

I have a table showing total sales this year for a week, total sales last year for the same week, and I also want period to date for this year and last year.

Week, period and year are all variables named ThisWeek, ThisPeriod and ThisYear (ther is also one for LastYear)

Currently the expression looks like this:

Sum (IF(DWH_OP_WEEK <=ThisWeek

AND DWH_OP_DATE_YEAR=ThisYear

AND DWH_OP_DATE_PERIOD=ThisPeriod,SALES_IM_SALES_VALUE_GROSS))

It works fine for period to date at the end of the period, but if I want to look back at week 2 period 1 for example, it still shows me total Period To Date for the whole period (when i only want to see the Period to Date up to week 2).

Any suggestions would be amazing!

Thanks

Re: Newbie needs help with Month To Date

Anonymous — Thu, 28 Feb 2013 03:27:23 GMT

Hi,

Take a look at the date & time functions (use the F1 help in QV).

Maybe you could use InWeekToDate()? or InMonthToDate()?

topic Newbie needs help with Month To Date in QlikView

Newbie needs help with Month To Date

Re: Newbie needs help with Month To Date