topic Re: Get Previous in current in QlikView

Get Previous in current

Tue, 20 May 2014 14:47:34 GMT

Hi,

Can you please help to fix this issue :

I need to get the previous value of each field and show it instead of the current one example:

Year Sales

2010 10

2011 25

2012 560

2013 58

What i want to get is :

Year Sales

2010 0

2011 10

2012 25

2013 560

Is it possible with qlikview ? Can you help please?

Thanks

Tue, 20 May 2014 14:50:24 GMT

If this is a pivot table use the Above() function or Sum({$<Year={$(=Max(Year)-1)}>} Sales)

Tue, 20 May 2014 15:02:13 GMT

Hi,

Thanks for your response but It doesn't work ... please see attached qvw.

Tue, 20 May 2014 15:13:45 GMT

Attached