Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aamir_bhellar
Partner - Contributor II
Partner - Contributor II

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]),


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

)
,0)

 

Can any one help .

 

Thanks 

 

Labels (1)
3 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
aamir_bhellar
Partner - Contributor II
Partner - Contributor II
Author

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? 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)