Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Year over Year analysis in Qliksense 3.0

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:

DATEAMT
4/7/20164986049865
4/7/20159073587457
5/8/201597707669

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?

Tags (1)
3 Replies
shraddha_g
Honored Contributor III

Re: Year over Year analysis in Qliksense 3.0

Create those fields in Script

or

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

lakshmikandh
Valued Contributor II

Re: Year over Year analysis in Qliksense 3.0

Try creating it as measure

Re: Year over Year analysis in Qliksense 3.0

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