While selecting currentYear, I wanna show value also for previous year

[#1]

How do I do that?

I tried

CurrentYear	Sum(currentYear)	Sum(previousYear)
x	x	x

for the Sum(previousYear) i tried this.

"SUM({<Year=Year-1>}amount)"  , however it still shows amount for 2015, and not for 2014

[sasiparupudi1]

try

SUM({<Year=max(Year)-1>} amount)

hth

Sasi

[#3]

Sum({$<Year={$(=Year(Today())-1)}>}amount)

Bryant

[petter]

Something like this should work for you. But remember not to use the year among the dimensions when you want different years in your expressions. If you do it will force the chart to show the expressions on not one line but multiple lines...

[mjm]

Hello Saw,

Can I refer you to a blog by hic.

Year-over-Year Comparisons

This will help you with performing year on year comparison.

If this helps, please mark this as helpful and correct.

Thanks,

Mark

Qlik

[#6]

ok. i will have a read on it first. In the mean time, i would attach the qvf file. for reference.