Qlikview Expression Issue

[#1]

Hi,

I am designing a qlikview application.Where in my select field is "Person_Key".

I will be calculating weight loss for each Person_Key.

Say for eg:For Person_key : 4208009,WeightLoss Expression should be Rnk2(WeightAns) -Rnk1(WeighAns) i,e ;123-123=0.

Can anyone help me with the expression for this,

[simondachstr]

Use set analysis:

Sum({$<RNK={'2'}> WEIGHT_ANS) - Sum({$<RNK={'1'}> WEIGHT_ANS

[MayilVahanan]

Hi

Try like this

use dimension, person_key and expression like

Sum({<RNK={2}> WEIGHT_ANS) - Sum({<RNK={1}>} WEIGHT_ANS)