topic Re: Not able to get PYMTD in QlikView

Not able to get PYMTD

renuka_sasikumar — Tue, 16 Sep 2014 11:12:46 GMT

Hi,

I have

LOAD StartDate,

EndDate,

Cycle,

AutoNumberHash128(Year&''&Cycle) as CycleNo,

Year as fYear

From ....qvd;

in which I m showing Revenue as per MTD but even I want to show PYMTD

and also I have done Interval Match.

I tried by creating Variable its picking the StartDate but not the EndDate for PYMTD.

Can anyone pls help me how to go about it.

Thanks & Regards,

Renuka

Re: Not able to get PYMTD

dinuwanbr — Tue, 16 Sep 2014 11:26:09 GMT

Hi,

Why don't you use set analysis for PYMTD? and if you upload the qvw file it will be easy to give you a solution. (by seeing above codes can't get an idea.)

-BR,

dinu1

Re: Not able to get PYMTD

senpradip007 — Tue, 16 Sep 2014 11:28:07 GMT

Can you upload sample qvw?

Re: Not able to get PYMTD

Anonymous — Tue, 16 Sep 2014 11:54:07 GMT

MTD:

=SUM({<StartDate = , EndDate = {'>=$(=MonthStart(StartDate ))<=$(=Today())'}>}Cycle)

PYMTD:

=SUM({<StartDate = , EndDate = {'>=$(=MonthStart(StartDate,-12))<=$(=AddYears(Today(),-1))'}>}Cycle)

Re: Re: Not able to get PYMTD

renuka_sasikumar — Wed, 17 Sep 2014 05:43:01 GMT

Hi,

Here is the atached File in which the StartDate & EndDate for same month But different Year it is different.

Thanks & Regards,

Renuka.