topic DTD and MTD in QlikView

DTD and MTD

Tue, 07 Apr 2015 06:22:37 GMT

Dear Gurus,

Could you please help me is resolving the below requirements.

Table:
LOAD * INLINE [
    Date, Exp
    01/03/2015, 15
    02/03/2015, -5
    03/03/2015, 25

01/04/2015, 10

02/04/2015, -5

03/04/2015, 20

];

Requirements:

1. If 1/03/2015 select then result should be
Date DTD MTD
01/03/2015 15 15

2. If 01/03/2015 and 02/03/2015 Select then result should be
Date               DTD      MTD
01/03/2015      15         15
02/03/2015      -5          10            (=15-5)

3. If 02/03/2015 and 03/03/2015 Select then result should be
Date            DTD   MTD
02/03/2015   -5      10                 (=15-5)
03/03/2015   25      35                 (=15-5+25)

4. If 02/04/2015 and 03/04/2015 Select then result should be
Date            DTD   MTD
02/04/2015   -5      5                 (=10-5)
03/04/2015   20      25                (=10-5+20)

Thanks in advacne and please do let me know in case of any clarification

Re: DTD and MTD

Tue, 07 Apr 2015 06:30:11 GMT

Please find the attached Document

Re: DTD and MTD

PrashantSangle — Tue, 07 Apr 2015 06:41:42 GMT

Hi,

If Date is your dimension, For DTD just write sum(Sales)

and for MTD

Create Day field in Script and nullify it in expression

try like

sum({<Date={">=$(=date(min(Date)))<=$(=date(max(Date)))"},Day=>}Sales)

Regards

Re: DTD and MTD

Tue, 07 Apr 2015 06:49:13 GMT

Please find the attached Document

Re: DTD and MTD

timanshu — Tue, 07 Apr 2015 07:07:23 GMT

Hi,

PFA QVW App and Screenshot.

Re: DTD and MTD

senpradip007 — Tue, 07 Apr 2015 07:24:30 GMT

PFA. Hope it will help.