Calculated Measures to create new column based on IF condition
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]),
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 .