Year over Year analysis in Qliksense 3.0

[#1]

Hi, my question is regarding Year over year analysis. I tried creating a dimension with below function but it is showing as invalid dimension

if(InYearToDate(Date, $([Week Ending.autoCalendar.Date]), 0), 1, 0)

AS [Cal IsInYTD],

Sum( {$<IsInYTD={1}, <IsLastYear={1}>} [IRA.MRD Amount Due for 2016] ),

if(InYearToDate(Date, $([Week Ending.autoCalendar.Date]), -1), 1, 0)

AS [Cal IsInLastYTD],

Sum( {$<IsInYTD={1}, <IsCurrentYear={1}>} [IRA.MRD Amount Due for 2016] )

My data is like this:

DATE	AMT
4/7/2016	4986049865
4/7/2015	9073587457
5/8/2015	97707669

Please help, I saw lot of discussion over this but i m not clear where to put the function.

q1. Should i edit data through data load editor?

q2. Should create a new dimension or measure and put this function to use?

q3. Should i add this in any measure that m using a graph?

[shraddha_g]

Create those fields in Script

or

Try without using AS [Cal IsInYTD] and AS [Cal IsInLastYTD]

[lakshmikandh]

Try creating it as measure

[kaushiknsolanki]

Hi,

You can use the set analysis to get year on year data.

Find below link for more help.

Set Analysis for certain Point in Time

Regards,

Kaushik Solanki