Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try
SUM({<Year=max(Year)-1>} amount)
hth
Sasi
Sum({$<Year={$(=Year(Today())-1)}>}amount)
Bryant
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...
Hello Saw,
Can I refer you to a blog by hic.
This will help you with performing year on year comparison.
If this helps, please mark this as helpful and correct.
Thanks,
Mark
Qlik
ok. i will have a read on it first. In the mean time, i would attach the qvf file. for reference.