topic Chart Calculation option in QlikView https://community.qlik.com/t5/QlikView/Chart-Calculation-option/m-p/814666#M1030751 <HTML><HEAD></HEAD><BODY><P>Hi Every one,</P><P> <BR />I have 5 asset classes in my chart and periods are P0 to P1, out of 5 asset classes 1 is OTC Derivative, when I make selection of OTC and Period=P0 values should be added to other periods(P1 to P15) and you can find current chart and it should be change to my requirement.</P><P>Make sure that this change should not reflect to other selections.</P><P> <BR />Current expression is: if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))</P><P>For ex: P0=10, P1=20,P2=5 then if select on OTC P0 value should be added to P1 to other periods.</P><P></P><P>Like our ex: after selection(OTC) P0=10 , P1=30(P0+P1), P2=15(P0+P2).</P><P><BR />PFA for reference</P><P> <BR />Thanks for your help in advance.</P><P>Raj</P></BODY></HTML> Tue, 03 Feb 2015 12:10:47 GMT 2015-02-03T12:10:47Z Chart Calculation option https://community.qlik.com/t5/QlikView/Chart-Calculation-option/m-p/814666#M1030751 <HTML><HEAD></HEAD><BODY><P>Hi Every one,</P><P> <BR />I have 5 asset classes in my chart and periods are P0 to P1, out of 5 asset classes 1 is OTC Derivative, when I make selection of OTC and Period=P0 values should be added to other periods(P1 to P15) and you can find current chart and it should be change to my requirement.</P><P>Make sure that this change should not reflect to other selections.</P><P> <BR />Current expression is: if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))</P><P>For ex: P0=10, P1=20,P2=5 then if select on OTC P0 value should be added to P1 to other periods.</P><P></P><P>Like our ex: after selection(OTC) P0=10 , P1=30(P0+P1), P2=15(P0+P2).</P><P><BR />PFA for reference</P><P> <BR />Thanks for your help in advance.</P><P>Raj</P></BODY></HTML> Tue, 03 Feb 2015 12:10:47 GMT https://community.qlik.com/t5/QlikView/Chart-Calculation-option/m-p/814666#M1030751 2015-02-03T12:10:47Z