topic Re: Calculate from Previous record in QlikView

Calculate from Previous record

Fri, 04 Jul 2014 06:57:25 GMT

Hi Everyone,

Can somebody help me how to calculate data from previous entry?

Please note that I use a cross table.

Temp1:

CrossTable(MONTHMMC, [DataC], 2)

LOAD YEAR_ as YYYYC,TYPE_ as [TYPEC],A01 as APR,A02 as MAY, A03 as JUN,A04 as JUL,

A05 as AUG, A06 as SEP, A07 as OCT,A08 as NOV,A09 as DEC,A10 as JAN, A11 as FEB,

A12 as MAR,TTL as TTL

FROM

[..\Data\QVD\C_OUT.QVD]

(qvd);

Concatenate(Result)

LOAD * Resident Temp1;

DROP Table Temp1;

It should compute this way. Can this be done on the expression of Chart Properties?

Thank you,

Re: Calculate from Previous record

avinashelite — Fri, 04 Jul 2014 07:06:05 GMT

Hi Esmark,

Please use the Rangesum and above function together.

Please find the attachment for the sample qvw

Regards,

@vi

Re: Calculate from Previous record

tresB — Fri, 04 Jul 2014 07:09:01 GMT

Have a look at above()/below() /before()/after(). If you are using a straight table, below() would be helpful, if pivot - after().

Re: Calculate from Previous record

Fri, 04 Jul 2014 07:57:50 GMT

PFA the attached solution.

Re: Calculate from Previous record

Fri, 04 Jul 2014 09:43:13 GMT

Hi All,

I am using this expression in getting each column value.

How will I use the before() or RangeSum() using the below definition?

Re: Calculate from Previous record

Fri, 04 Jul 2014 09:46:04 GMT

Hi Shrivas,

I tried to use the expression you've made but I got this.

Re: Re: Calculate from Previous record

avinashelite — Fri, 04 Jul 2014 09:55:57 GMT

Hi Esmark,

Do you need to hard code all the months as an Expression????.

Insted of that you can use a Pivot table and do the pivoting rite???

Please find the attachment, hope it helps you.

Regards,

@vi

Re: Re: Calculate from Previous record

Fri, 04 Jul 2014 11:13:22 GMT

I think this is want you need.

Re: Calculate from Previous record

Mon, 07 Jul 2014 01:14:43 GMT

Thank you everyone.