Get number from previous period

[tracycrown]

Dear all

Can someone help to advise how to present $300 from previous period (2009) to current period (2010).

    Year                   2009             2010             2011

Capital employed                        $300             $348

Thank You

Tracy

[phaneendra_kunc]

Have you tried "above" or "below" ?

[MK_QSL]

Above(sum(Data))

[Anonymous · Accepted solution]

Hi,

What do you think about this ?

Regards,

Julien.

[cristian_av]

You can also use "Point-In-Time" with Set Analysis. But maybe it is too complicated it what you need is something simple.

http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/

You can get More information in the eBook: QlikView for Developers 11, Chapter 11.

[tracycrown]

Dear Pheneendra, Manish and Julien

Thank you so much for your quick response, my problem has been resolved.

Kindly advise Is there another way using sum(if (year =Year-1,Data) ?.

Thank you

Tracy

[tracycrown]

Hi Julien

I cannot get the same answer for Opening in table 2, please advise how to get the same answer as table 1.

Thank you very much

Tracy

[tracycrown]

Hi Cristian

I find it hard to understand but many thanks for your advice.

Best Rdgs

Tracy .

[Anonymous]

Hi Tracy,

Please find the new application with your new table.

Please recommend me if the result is correct.

Regards,

Julien.