Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get Previous in current


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

3 Replies
Not applicable

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

Not applicable

Hi,

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

Not applicable

Attached