Issue in Expression -Qlikview

[#1]

Hi,

1)Total Members : 100

Expression Used : = (SUM(IF(FLAG_MEM_PERSON_KEY=1 , FLAG_MEM_PERSON_KEY)))

2)Total Members who lost weight :

=(SUM(IF(FLAG_MEM_PERSON_KEY=1 and $(WeighLoss) < 0   , FLAG_MEM_PERSON_KEY)))

So WeighLoss is a variable that has weightloss value for each Userid.

Problem:

For Total Members who lost weight  i should get a value as 1 (because UserID has a negative value which is less than 0.

But unfortunately this is not happening.

Can you please check the attached qvw .

[#2]

Thanks a lot Kaushik

it worked

[#3]

Yea very true!!

Will surely follow your advice