topic Re: Calculated Measures to create new column based on IF condition in App Development

Calculated Measures to create new column based on IF condition

aamir_bhellar — Thu, 23 Dec 2021 18:28:44 GMT

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

Re: Calculated Measures to create new column based on IF condition

Anil_Babu_Samineni — Tue, 29 Dec 2020 16:59:51 GMT

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

Re: Calculated Measures to create new column based on IF condition

aamir_bhellar — Tue, 29 Dec 2020 17:05:34 GMT

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 .

Re: Calculated Measures to create new column based on IF condition

Anil_Babu_Samineni — Tue, 29 Dec 2020 17:08:02 GMT

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