Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
d_ankusha
Contributor 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
Highlighted
Partner
Partner

Re: To optimise dynamic calculation in front end in Qlik Sense

You have a sample app?

Highlighted
d_ankusha
Contributor II

Re: To optimise dynamic calculation in front end in Qlik Sense

I can not share data or app.

Highlighted

Re: To optimise dynamic calculation in front end in Qlik Sense

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)