topic Re: Calculations while importing in QlikView https://community.qlik.com/t5/QlikView/Calculations-while-importing/m-p/401742#M149496 <HTML><HEAD></HEAD><BODY><P>Try this.</P><P></P><P>Load *,Expense * -1 as New_Expense</P><P>From abc.XLS</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 28 Mar 2013 06:46:04 GMT kaushiknsolanki 2013-03-28T06:46:04Z Calculations while importing https://community.qlik.com/t5/QlikView/Calculations-while-importing/m-p/401741#M149495 <HTML><HEAD></HEAD><BODY><P>I need a field, Expense, to be multiplied by (-1) at the time of importing itself, is that possible? I do not want to write that in the expression for each object throughout the file, which is what i do at present. Following is a snippet of the code:</P><P></P><P>Load*,</P><P> [Expense],</P><P></P><P>from ...abc.XLS</P></BODY></HTML> Thu, 28 Mar 2013 06:41:01 GMT https://community.qlik.com/t5/QlikView/Calculations-while-importing/m-p/401741#M149495 2013-03-28T06:41:01Z Re: Calculations while importing https://community.qlik.com/t5/QlikView/Calculations-while-importing/m-p/401742#M149496 <HTML><HEAD></HEAD><BODY><P>Try this.</P><P></P><P>Load *,Expense * -1 as New_Expense</P><P>From abc.XLS</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 28 Mar 2013 06:46:04 GMT https://community.qlik.com/t5/QlikView/Calculations-while-importing/m-p/401742#M149496 kaushiknsolanki 2013-03-28T06:46:04Z