topic Re: Get number from previous period in QlikView

Get number from previous period

tracycrown — Fri, 29 Aug 2014 15:09:14 GMT

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

Re: Get number from previous period

phaneendra_kunc — Fri, 29 Aug 2014 15:15:15 GMT

Have you tried "above" or "below" ?

Re: Get number from previous period

MK_QSL — Fri, 29 Aug 2014 15:20:14 GMT

Above(sum(Data))

Re: Get number from previous period

Anonymous — Fri, 29 Aug 2014 15:22:18 GMT

Hi,

What do you think about this ?

Regards,

Julien.

Re: Get number from previous period

cristian_av — Fri, 29 Aug 2014 16:07:25 GMT

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.

Re: Get number from previous period

tracycrown — Fri, 29 Aug 2014 17:07:00 GMT

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

Re: Get number from previous period

tracycrown — Sat, 30 Aug 2014 16:01:23 GMT

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

Re: Get number from previous period

tracycrown — Sat, 30 Aug 2014 16:06:26 GMT

Hi Cristian

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

Best Rdgs

Tracy .

Re: Re: Get number from previous period

Anonymous — Tue, 02 Sep 2014 08:39:39 GMT

Hi Tracy,

Please find the new application with your new table.

Please recommend me if the result is correct.

Regards,

Julien.