Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
d_ankusha
Creator II
Creator II

To optimise dynamic calculation in front end in Qlik Sense

Hi All,

I have an expression working in front end : IF(ISNULL(if( [0PSTNG_DATE]<= GetFieldSelections(Date) and [0SP_GL_IND]=' ' AND [0FI_DOCSTAT]='O' AND ZSOURCE<>'T', Sum([0DEB_CRE_LC] ))), '0', if([0PSTNG_DATE]<=GetFieldSelections(Date) and [0SP_GL_IND]=' ' AND [0FI_DOCSTAT]='O' AND ZSOURCE<>'T', Sum([0DEB_CRE_LC] ) ))
+
if( [0PSTNG_DATE]<=GetFieldSelections(Date) and [0SP_GL_IND]=' ' and ZSOURCE<>'T'and [0CLEAR_DATE]> GetFieldSelections(Date), Sum([0DEB_CRE_LC] ))

This expression calculation is going out of memory as the data is from 2006 -2019. How can I optimise it? I tried doing this calculation on backend but since it contains manual selection in field Date , I was not able to come up with correct values. 

Labels (1)
3 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

You have a sample app?

d_ankusha
Creator II
Creator II
Author

I can not share data or app.

Anil_Babu_Samineni

Perhaps this

If(IsNull(Sum({<[0PSTNG_DATE]={"=[0PSTNG_DATE]<=GetFieldSelections(Date)"}, [0SP_GL_IND]={''}, [0FI_DOCSTAT]={0}, ZSOURCE-={'T'}>} [0DEB_CRE_LC])), 0,
Sum({<[0PSTNG_DATE]={"=[0PSTNG_DATE]<=GetFieldSelections(Date) and [0CLEAR_DATE]>GetFieldSelections(Date)"}, [0SP_GL_IND]={''}, ZSOURCE-={'T'}>*<[0PSTNG_DATE]={"$('<='&GetFieldSelections(Date))"}, [0FI_DOCSTAT]={0}}>} [0DEB_CRE_LC]))

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)