Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Condition Ok to me, Where this is not working. May be split expression and try?
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 .
May be ignore the fields where you are getting reflected in the expression?