topic How to Code Calculation in QlikView https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147088#M25545 <HTML><HEAD></HEAD><BODY><P>Had twice the same field in the select, a Ctrl-V / P that went wrong and i didn't verify the code of the select.</P></BODY></HTML> Thu, 18 Jun 2009 19:51:54 GMT 2009-06-18T19:51:54Z How to Code Calculation https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147086#M25543 <HTML><HEAD></HEAD><BODY><P style="padding-left: 30px;">How should i code this calculation for a reload ..</P><P style="padding-left: 30px;"></P><P style="font-style: italic; padding-left: 30px">ANOBOB:</P><BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold; padding-left: 30px">SQL SELECT</P><B></B><P style="font-weight: bold; padding-left: 30px"></P><P style="padding-left: 30px;"></P><B><I>'$(vCmp)/'</I></B> || BOREFK AS C_KEREFK, ANOBOB.BOYEAR AS ASW_YEAR, ANOBOB.BODAOB, ANOBOB.BODAOB<BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold; padding-left: 30px">FROM</P><B></B><P style="font-weight: bold; padding-left: 30px"></P><P style="padding-left: 30px;"></P><B><I>$(vDb)</I></B>.ANOBOB ANOBOB<BR /><BR /> <P></P><P style="padding-left: 30px;">WHERE</P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;">ANOBOB.BOSUTA = 'A11' AND ANOBOB.BOYEAR &gt;= 2008;</P><BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold; padding-left: 30px">LOAD</P><B></B><P style="font-weight: bold; padding-left: 30px"></P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;">I Know that this could be done in the SQL, but in other more complex selects some fields are very long cases, so calculating them would crate a even more crazy sql statement.</P>C_KEREFK, ASW_YEAR, (BODAOB-BODAOB) <B>AS</B> BODOPEN <B>RESIDENT</B> ANOBOB; <BR /><BR /></BODY></HTML> Thu, 18 Jun 2009 19:08:12 GMT https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147086#M25543 2009-06-18T19:08:12Z How to Code Calculation https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147087#M25544 <HTML><HEAD></HEAD><BODY><P>Sorry found the error in the code</P></BODY></HTML> Thu, 18 Jun 2009 19:11:58 GMT https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147087#M25544 2009-06-18T19:11:58Z How to Code Calculation https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147088#M25545 <HTML><HEAD></HEAD><BODY><P>Had twice the same field in the select, a Ctrl-V / P that went wrong and i didn't verify the code of the select.</P></BODY></HTML> Thu, 18 Jun 2009 19:51:54 GMT https://community.qlik.com/t5/QlikView/How-to-Code-Calculation/m-p/147088#M25545 2009-06-18T19:51:54Z