topic Re: YTD based on the selection in QlikView

YTD based on the selection

Fri, 14 Feb 2014 07:31:59 GMT

Hi all ,

I want to be able to compare last years data and this years data based on current selections. Meaning that if I select 2013 and February, I will compare January + February this year against January and February last Year.

Can anyone tell what is the expression for this?

Thanks in advance,

Soumya

Re: YTD based on the selection

vikasmahajan — Fri, 14 Feb 2014 07:39:41 GMT

PFA sample will help you to arrive the same.

Vikas

Re: YTD based on the selection

jagan — Fri, 14 Feb 2014 07:49:05 GMT

Hi,

Try like this

For Current Year

=Sum({$<YearDimensionName=, MonthDimensionName= QuarterDimensionName=, DateDimensionName={'>=$(=Year(Max(DateDimensionName)))<=$(=Date(Max(DateDimensionName)))'}>}SALES_VALUE)

For previous year

Sum({$<YearDimensionName=, MonthDimensionName= QuarterDimensionName=, DateDimensionName={'>=$(=YearStart(Max(DateDimensionName), -1))<=$(=AddYears(Max(DateDimensionName), -1))'}>}SALES_VALUE)

Regards,

Jagan.