Calculated Measures to create new column based on IF condition

[aamir_bhellar]

Hello Qlik Experts , 

I have query about Calculated measures , actually i want to develop column based on different other columns using if condition , in the execl  form same formula work fine , but when i am using qlik it can't give me the proper figure when i am using the filters . 

here is the Formula of Qlik :

if
(
[CLM_File.DEPARTMENTCODE]='MTR',
if
(
[Total Gross]<=[Perority],0,
if
(
[Paid]>[Perority],RangeSum([Total Gross],-[Paid]),

RangeSum([Total Gross],-[Paid]) - RangeSum([Perority],-[Paid])
)

)
,0)

Can any one help .

Thanks 

[Anil_Babu_Samineni]

Condition Ok to me, Where this is not working. May be split expression and try?

[aamir_bhellar]

Hi Anil, 

Thank you very much for your support .

Actually i have different columns like , Paid and OS they are using As_OF_DATE filter , when there is no filter it give me the correct result as i am using max year in the expression , but when i am selecting the Filter like year and month so the variable take all the dates from year start to year selected . 

at that moment this formula not working . 

[Anil_Babu_Samineni]

May be ignore the fields where you are getting reflected in the expression?