topic Set Analysis Date range in QlikView

Set Analysis Date range

Tue, 28 May 2013 05:05:06 GMT

Hi All,

I need to get the sum of sales for date range between x to y date. My Expression look like this

=(sum({$<PROMOTION_CODE=,PROMOTION_NAME=,STYPE_KEY={2},SALES_DATE = {">=$(=date(max(SALES_DATE)-21))<=$(=date(max(SALES_DATE)-1))"}>}DAY_SLS_ACT_BC))

I checked in header whether the date parameter is passing or not,

=(sum({$<PROMOTION_CODE=,PROMOTION_NAME=,STYPE_KEY={2},SALES_DATE = {">=20/02/2013<=12/03/2013"}>}DAY_SLS_ACT_BC))

But i'm get the sum as "0". Please help me to identify where i'm wrong in this expression

Thanks in advance,

Selva

sushil353 — Tue, 28 May 2013 05:09:55 GMT

Hi,

please make sure that the SALES_DATE and the parameter format are same...

if yes then please share sample application..

HTH

Sushil

Tue, 28 May 2013 05:35:26 GMT

Thanks Sushil,

Format is wrong. Now fixed

Selva