Cell Referencing in Qlikview

Mon, 02 Jul 2012 10:37:18 GMT

Hi,

I need to perform some calculation based on a few parameters using Qlikview. These calculations are dependent on the variable information.

where 2.511666 is arrived with the formulae =IF(AND(B2="MR",C2=C3),(I2-I3)/I3*100,"NA")

Can you please advise how to do the same in qlikview?

Re: Cell Referencing in Qlikview

jonathandienst — Mon, 02 Jul 2012 10:58:17 GMT

Assuming column 'I' is the column with header 5Y:

If(CDS_CLAUSE = 'MR' And ENTITY_NAME = Below(ENTITY_NAME), ([5Y] - Below([5Y]))/Below([5Y])*100, 'NA')

CDS_CLAUSE , ENTITY_NAME , 5Y must all be included in the table and the table must be in the correct sort order.

Hope that helps

Jonathan