topic Re: Qlikview Expression Issue in QlikView

Qlikview Expression Issue

Tue, 05 Nov 2013 13:07:51 GMT

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 — Tue, 05 Nov 2013 13:11:08 GMT

Use set analysis:

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

MayilVahanan — Tue, 05 Nov 2013 14:32:49 GMT

Try like this

use dimension, person_key and expression like

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