topic Re: set analysis in QlikView

topic Re: set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/989577#M528691 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">round(</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">     (Only({<Region = >}used)/Only(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">{<Region = >}</SPAN>available))*100)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">,.01)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">Or use Sum instead of Only<BR /></SPAN></P></BODY></HTML> Mon, 07 Sep 2015 14:14:33 GMT MK_QSL 2015-09-07T14:14:33Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/989576#M528690 <HTML><HEAD></HEAD><BODY><P>how to include set analysis inside round(((used/available)*100),.01)? i want to give Region= in order to not affected by Region selection</P></BODY></HTML> Mon, 07 Sep 2015 14:12:40 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/989576#M528690 Anonymous 2015-09-07T14:12:40Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/989577#M528691 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">round(</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">     (Only({<Region = >}used)/Only(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">{<Region = >}</SPAN>available))*100)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">,.01)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">Or use Sum instead of Only<BR /></SPAN></P></BODY></HTML> Mon, 07 Sep 2015 14:14:33 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/989577#M528691 MK_QSL 2015-09-07T14:14:33Z