topic Re: Calculated Expression Error in QlikView https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437103#M163047 <HTML><HEAD></HEAD><BODY><P>Information is not enough. Can you upload sample.</P><P>There will be lot of reasons for that issue.</P></BODY></HTML> Wed, 13 Mar 2013 15:05:22 GMT CELAMBARASAN 2013-03-13T15:05:22Z Calculated Expression Error https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437102#M163046 <HTML><HEAD></HEAD><BODY><P><OBJECT classid="CLSID:A806E1D7-B077-415E-AF08-28AFE10DDF4A" height="294" id="QlikOCX" width="424"><PARAM name="_Version" value="720896" /><PARAM name="_ExtentX" value="11218" /><PARAM name="_ExtentY" value="7778" /><PARAM name="_StockProps" value="0" /><PARAM name="DocName" value="\\dfspr1\Users\N\Neringa.Mikulskyte\documents\MRA\Application\MRA_tool_test.qvw" /><PARAM name="UserName" /><PARAM name="Password" /><PARAM name="Publisher" /><PARAM name="AccessMode" value="0" /><PARAM name="AllowDialog" value="1" /><PARAM name="SRC" /><PARAM name="AutoScan" value="1" /><PARAM name="ProductLevel" value="274254420" /><PARAM name="ObjectID" value="Document\CH41" /></OBJECT></P><P>Hi,</P><P></P><P>% of DF is a calculated expression but it does not work. It contains the following:</P><P></P><P>=LOSS_OVER_IM/sum(CBBC)</P><P></P><P>CBBC is loaded from the database. Why is the calculation not working?</P></BODY></HTML> Wed, 13 Mar 2013 14:49:35 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437102#M163046 2013-03-13T14:49:35Z Re: Calculated Expression Error https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437103#M163047 <HTML><HEAD></HEAD><BODY><P>Information is not enough. Can you upload sample.</P><P>There will be lot of reasons for that issue.</P></BODY></HTML> Wed, 13 Mar 2013 15:05:22 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437103#M163047 CELAMBARASAN 2013-03-13T15:05:22Z Re: Calculated Expression Error https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437104#M163048 <HTML><HEAD></HEAD><BODY><P>Sorry, I attached the table in original message but for some reason it didn’t show up.</P><P></P><P>Table should look like this:</P><P></P><P>Date</P><P></P><P>No</P><P></P><P>Loss over IM</P><P></P><P>% of DF</P><P></P><P>12/02/2013</P><P></P><P>652</P><P></P><P>-152352</P><P></P><P>=LOSS_OVER_IM/sum(CBBC)</P><P></P><P></P><P></P><P>CBBC field is loaded from a database.</P><P></P><P>Loss over IM and % of DF are expressions and other fields dimensions. In the calculated field only (–) is displayed rather than percentage.</P><P></P><P>Hope this makes more sense now.</P></BODY></HTML> Wed, 13 Mar 2013 16:28:58 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Error/m-p/437104#M163048 2013-03-13T16:28:58Z