topic Re: How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ? in App Development https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072957#M17586 <HTML><HEAD></HEAD><BODY><P>My QS file </P></BODY></HTML> Thu, 21 Apr 2016 01:16:27 GMT paulyeo11 2016-04-21T01:16:27Z How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ? https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072955#M17584 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;"></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;">May i know how to remove the condition on If([Exec P&amp;L Level] = 's', '' from below expression ?<SPAN style="font-size: 16px;">:-</SPAN></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;"></P><P>Money(RangeSum( Above(RangeSum(Above(If([Exec P&amp;L Level] = 's', '', Sum({&lt;year, month&gt;}[Amount]*1)), 0, RowNo())))</P><P>, -Sum(TOTAL Aggr(If([Exec P&amp;L Level] = 's', '', Sum({&lt;year, month&gt;}[Amount]*1)), YearMonth))) , $(vMoneyFormatK_GL))</P><P></P><P>Paul</P></BODY></HTML> Thu, 21 Apr 2016 01:14:56 GMT https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072955#M17584 paulyeo11 2016-04-21T01:14:56Z Re: How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ? https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072956#M17585 <HTML><HEAD></HEAD><BODY><P>Waiting for the sample <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Apr 2016 01:15:50 GMT https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072956#M17585 sunny_talwar 2016-04-21T01:15:50Z Re: How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ? https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072957#M17586 <HTML><HEAD></HEAD><BODY><P>My QS file </P></BODY></HTML> Thu, 21 Apr 2016 01:16:27 GMT https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072957#M17586 paulyeo11 2016-04-21T01:16:27Z Re: How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ? https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072958#M17587 <HTML><HEAD></HEAD><BODY><P>This seems to be working in QV, can your try in QS</P><P></P><P><STRONG>=Money(RangeSum(</STRONG></P><P><STRONG>Above(RangeSum(Above(Sum({&lt;year, month&gt;}[Amount]*-1), 0, RowNo()))),</STRONG></P><P><STRONG>-Sum(TOTAL Aggr(Sum({&lt;year, month&gt;}[Amount]*-1), YearMonth)))</STRONG></P><P><STRONG>, $(vMoneyFormatK_GL))</STRONG></P><P></P><P>Seems to be working in QS for the selections you have, not sure what happens for other selections</P></BODY></HTML> Thu, 21 Apr 2016 01:22:04 GMT https://community.qlik.com/t5/App-Development/How-to-remove-the-condition-on-If-Exec-P-L-Level-s-from-my/m-p/1072958#M17587 sunny_talwar 2016-04-21T01:22:04Z