topic Re: set analysis problem in QlikView https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367855#M1172749 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum({&lt;model={"=(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum(Stock_value)-sum(Stock_qty))</SPAN>&gt;0"}&gt;}MAP)*fabs(sum(Stock_value)-sum(Stock_qty))</SPAN></P></BODY></HTML> Thu, 26 Jul 2012 18:40:37 GMT CELAMBARASAN 2012-07-26T18:40:37Z set analysis problem https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367852#M1172746 <HTML><HEAD></HEAD><BODY><P>how can i convert this expression into set analysis expression</P><P></P><P>if(sum(Stock_value)-sum(Stock_qty)&gt;0,sum(MAP)*fabs(sum(Stock_value)-sum(Stock_qty)))</P></BODY></HTML> Wed, 25 Jul 2012 19:11:29 GMT https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367852#M1172746 2012-07-25T19:11:29Z Re: set analysis problem https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367853#M1172747 <HTML><HEAD></HEAD><BODY><P>What dimensions you are using?</P></BODY></HTML> Wed, 25 Jul 2012 19:33:53 GMT https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367853#M1172747 CELAMBARASAN 2012-07-25T19:33:53Z Re: set analysis problem https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367854#M1172748 <HTML><HEAD></HEAD><BODY><P>model</P></BODY></HTML> Thu, 26 Jul 2012 04:38:57 GMT https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367854#M1172748 2012-07-26T04:38:57Z Re: set analysis problem https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367855#M1172749 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum({&lt;model={"=(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum(Stock_value)-sum(Stock_qty))</SPAN>&gt;0"}&gt;}MAP)*fabs(sum(Stock_value)-sum(Stock_qty))</SPAN></P></BODY></HTML> Thu, 26 Jul 2012 18:40:37 GMT https://community.qlik.com/t5/QlikView/set-analysis-problem/m-p/367855#M1172749 CELAMBARASAN 2012-07-26T18:40:37Z