Cell Referencing in Qlikview

[#1]

Hi,

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

CURVE	CDS_CLAUSE	ENTITY_NAME	TENOR	5Y	Result
AXL	MR	AAMI		705.57365	2.511666
AXL_NR	XR	AAMI		688.286202	NA
ABC_US	XR	ABC_US		77.134053	NA
ABS	MR	ABS_NEW		1033.911913	2.203319
ABS_NR	XR	ABS_NEW		1011.622641	NA

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?

[jonathandienst]

Hi

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