Year over Year,

Thu, 19 Jun 2014 13:19:53 GMT

Hello Team

I need to find the value for the year over year total sales.I am using this formula for to get the previous year value.

=num((Sum({[HMSlider]<[year]=$(VCurrentYear)>}SalesAmt )/1000),'$#,##0')

HMSlider is the Set analytics consist of jan,feb,March etc.

I am planning to have set analytics for the month and to find the YOY as of date .

means

last year jan-13 and current year jan 14 should have to compare

or last year jan-13.feb-13 and current year jan-14/feb-14 have to compare. for the actual sales happned.

Current year

=num((Sum({[HMSlider]<[year]=$(VCurrentYear)>}SalesAmt )/1000),'$#,##0')

Previous year

=num((Sum({[HMSlider]<[year]=$(VPreviousYear)>}SalesAmt )/1000),'$#,##0')

I am not getting the value ...

Remember Month is the common that is available in the list box like jan,feb,march....

Can any one give me idea or provide me the proper formula.

Re: Year over Year,

joshabbott — Thu, 19 Jun 2014 13:28:41 GMT

I'm not sure that HMSlider belongs in your expression. If it represents the selected month, it can just be taken out I would think. If you want month to equal the value of HMSlider, replacing the <[Year] = $..., you may want to use <[Month] = [HMSlider], [Year] = ....)

topic Re: Year over Year, in QlikView

Year over Year,

Re: Year over Year,