topic MTD Table in QlikView

MTD Table

Fri, 26 Aug 2011 09:57:50 GMT

Hi everybody,

Do you know how to do a MTD table in sript??

I have the following table and I need a NUM_SALES_MTD field

Table 1:

NUM_SALES,

PROVIDER_ID,

MARKET_ID,

DATE,

YEAR,

MONTH,

WEEK ;

If I'd have only one dimension I could use peek function but I need the other dimensions...

I have tried to make the expressions at the layout but it seems to require a lot of memory...(I have a lot of expressions and the system can't support the calculation)

any Idea?

regards,

David

MTD Table

Fri, 26 Aug 2011 10:48:01 GMT

If (YEAR= YEAR(today() and MONTH = Month(today(),NUM_SALES) as NUM_SALES_MTD

then just sum(NUM_SALES_MTD) in charts etc

MTD Table

its_anandrjs — Fri, 26 Aug 2011 10:57:49 GMT

Hi,

You need to create a MTD column by creating a field like

If ( Year = Year(Today()) and Monthend( today() ) , NUM_SALES) as MTD_Sales

Regards,

Anand

MTD Table

Fri, 26 Aug 2011 11:06:49 GMT

Hi,

I think you want group by here.

say :

load sum ( NUM_SALES ) as Num_Sales_MTD,

PROVIDER_ID,

MARKET_ID,

DATE,

YEAR,

MONTH,

WEEK

from <Your>.qvd

group by YEAR, MONTH;

HTH