topic Re: Calculating % difference between values in QlikView

Calculating % difference between values

Fri, 16 Dec 2011 15:20:23 GMT

Hello

I know this topic has been discussed many times on this forum, but I have a slightly different question. Please see the attached QV doc and spreadsheet.

I have some "triangle" data in QV. Triangle data shows the development of a figure by month for a set of origin months.

So for example, it shows all claims reported in Jan-11 and shows their financial position at end Jan-11 (development month=0), end Feb-11 (development month=1), end Mar-11 (development month=2) and so on. And on the next row it shows all claims reported in Feb-11 and shows their financial position at end Feb-11 (development month=0), end Mar-11 (development month=1) and so on. Have a look at the QV doc which should hopefully clarify!

I've made the triangle in QV no problem, but now I need two more triangles which show the difference between development months. The spreadsheet shows what I mean more clearly.

Is it possible to create these extra difference triangles?

Many thanks

James

Re: Calculating % difference between values

swuehl — Fri, 16 Dec 2011 15:55:10 GMT

Try using

=if( columnno()>1 and count([Total Paid]),sum([Total Paid])- before(sum([Total Paid])), if( count([Total Paid]),sum([Total Paid]),NULL() ))

and

=if( columnno()>1 and count([Total Paid]),(sum([Total Paid])- before(sum([Total Paid])))/before(sum([Total Paid])), NULL() )

as expressions. See also attached.

Regards,

Stefan

Re: Calculating % difference between values

Fri, 16 Dec 2011 16:36:31 GMT

Wonderful!

Re: Calculating % difference between values

kaushalview — Thu, 18 Apr 2013 12:14:55 GMT

Hi,

Swuel

I need your help for create a triangle report.

I have attached the triangle formate report.

regards

Kaushal Mehta