topic Detaching text box in QlikView https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480907#M1141601 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to display sum of max values from three fields in text object and i dont want this value to be changed with other selcetion.</P><P></P><P>In text box, "=max(Inv1_Energy)+max(Inv2_Energy)+max(Inv3_Energy)" and this value should not get changed with any other selection. </P><P></P><P>How to I do that? Please help</P><P></P><P>Thank you</P></BODY></HTML> Wed, 04 Sep 2013 11:43:59 GMT 2013-09-04T11:43:59Z Detaching text box https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480907#M1141601 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to display sum of max values from three fields in text object and i dont want this value to be changed with other selcetion.</P><P></P><P>In text box, "=max(Inv1_Energy)+max(Inv2_Energy)+max(Inv3_Energy)" and this value should not get changed with any other selection. </P><P></P><P>How to I do that? Please help</P><P></P><P>Thank you</P></BODY></HTML> Wed, 04 Sep 2013 11:43:59 GMT https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480907#M1141601 2013-09-04T11:43:59Z Re: Detaching text box https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480908#M1141602 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P></P><P>=max({1}Inv1_Energy)+max({1}Inv2_Energy)+max({1}Inv3_Energy)</P></BODY></HTML> Wed, 04 Sep 2013 11:52:35 GMT https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480908#M1141602 tresB 2013-09-04T11:52:35Z Re: Detaching text box https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480909#M1141603 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P>This is working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 05 Sep 2013 03:17:45 GMT https://community.qlik.com/t5/QlikView/Detaching-text-box/m-p/480909#M1141603 2013-09-05T03:17:45Z