Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT 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)