topic simple formula in QlikView

topic simple formula in QlikView https://community.qlik.com/t5/QlikView/simple-formula/m-p/613460#M685346 <HTML><HEAD></HEAD><BODY><P><SPAN class="s1">hi everyone :</SPAN></P><P><SPAN class="s1">is there a better way  to write (simplify) this formula <BR /></SPAN></P><P><SPAN class="s1">sum</SPAN>({1<<SPAN class="s2">TRIM</SPAN>={'$(vMaxS1)','$(vMaxS2)'}>}<SPAN class="s2">[QTY]</SPAN>)  /  <SPAN class="s1">sum</SPAN>( {1<<SPAN class="s2">TRIM</SPAN>={'$(vMaxS1)','$(vMaxS2)'}>} <SPAN class="s1">total</SPAN> <<SPAN class="s2">TRIM</SPAN>> <SPAN class="s2">[QTY]</SPAN>) </P><P></P><P>thanks</P></BODY></HTML> Wed, 05 Feb 2014 22:41:01 GMT mambi 2014-02-05T22:41:01Z simple formula https://community.qlik.com/t5/QlikView/simple-formula/m-p/613460#M685346 <HTML><HEAD></HEAD><BODY><P><SPAN class="s1">hi everyone :</SPAN></P><P><SPAN class="s1">is there a better way  to write (simplify) this formula <BR /></SPAN></P><P><SPAN class="s1">sum</SPAN>({1<<SPAN class="s2">TRIM</SPAN>={'$(vMaxS1)','$(vMaxS2)'}>}<SPAN class="s2">[QTY]</SPAN>)  /  <SPAN class="s1">sum</SPAN>( {1<<SPAN class="s2">TRIM</SPAN>={'$(vMaxS1)','$(vMaxS2)'}>} <SPAN class="s1">total</SPAN> <<SPAN class="s2">TRIM</SPAN>> <SPAN class="s2">[QTY]</SPAN>) </P><P></P><P>thanks</P></BODY></HTML> Wed, 05 Feb 2014 22:41:01 GMT https://community.qlik.com/t5/QlikView/simple-formula/m-p/613460#M685346 mambi 2014-02-05T22:41:01Z Re: simple formula https://community.qlik.com/t5/QlikView/simple-formula/m-p/613461#M685347 <HTML><HEAD></HEAD><BODY><P>I don't think so.</P><P></P><P>You are using set Analysis .</P></BODY></HTML> Wed, 05 Feb 2014 22:53:04 GMT https://community.qlik.com/t5/QlikView/simple-formula/m-p/613461#M685347 2014-02-05T22:53:04Z