Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
deep2021
Creator III
Creator III

Sum with nested if consumes a long time for reload

Hello Experts,

The below nested if condition with sum in the script consumes a long time for reload.

SUM( (IF(GROUP_CATEGORY='G:Contributions_PMA',ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Contributions Transferred',ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Contributions Reinvested',ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Distributions Income',ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Distributions Capital',ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Distributions Realized Gains',ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Distributions Redemption' OR
GROUP_CATEGORY='C:Redemptions Adjustments', ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Redemptions Transferred', ACTIVITY,0)+
IF(GROUP_CATEGORY='G:NII_PMA', ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Realized Gain Loss' OR
GROUP_CATEGORY='C:H_Unrealized Gain Loss Equity Side',ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Reverse Unrealized', ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Property Appreciation' OR
GROUP_CATEGORY='C:H_APRADJI' OR
GROUP_CATEGORY='C:H_Unealized Gain Loss Equity Side' OR
GROUP_CATEGORY='G:MI Valuation' OR
GROUP_CATEGORY='C:H_Investment Appreciation OLD' , ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Unrealized Gain Loss Incentive Fee', ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Appreciation FX Property', ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Unrealized Gain Loss FX Fund' OR
GROUP_CATEGORY='C:H_Investment Appreciation', ACTIVITY,0) +
IF(GROUP_CATEGORY='G:Syndication Costs Derivatives', ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Offering Costs', ACTIVITY,0)+
IF(GROUP_CATEGORY='G:GIPS Only Appreciation', ACTIVITY,0))*(-1)) AS Price_NAV_1

 

Can you please suggest  the alternative way for the same.

 

 

Thanks

Labels (2)
0 Replies