Code Help for CY vs LY?

rohitians — Thu, 21 Nov 2013 06:47:55 GMT

Hello All,

I have this report which is current year sales vs last year sales...

CY:

(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Gross Sales Amount])

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Return Amount])

)/100000

LY:

(Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},

[Posting Date]={">=$(=YearStart(max([Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}

>} [Gross Sales Amount])

-Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},

[Posting Date]={">=$(=YearStart(max([Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}

>} [Sales Return Amount])

)/100000

The Above code works fine until i use quarter and month as dimension ...

when i use financial year as dimension i dnt get the desired result please help...

Thanks and Regards,

Rohit

Re: Code Help for CY vs LY?

kaushiknsolanki — Thu, 21 Nov 2013 07:09:21 GMT

Hi,

Share your application.

Regards,

Kaushik Solanki

topic Code Help for CY vs LY? in QlikView

Code Help for CY vs LY?

Re: Code Help for CY vs LY?