topic Calculation in a text box in QlikView https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445112#M166038 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I am trying to do some calculation in a text box.</P><P></P><P>the expression looks like:</P><P></P><P></P><P>= Sum({1}Sales)/Sum({1}EmployeesCount)</P><P></P><P>I have used {1} so the list boxes dont effect the calcualtio as i am looking at average.</P><P></P><P>Now I want to apply one filter all the time as follow:&nbsp; I want this text box to show the same calculations but for three cities where I have a list box named city</P><P></P><P>City </P><P>Atlanta</P><P>NY</P><P>DC</P><P></P><P>Anybody can help..</P><P></P><P>Thxs</P></BODY></HTML> Tue, 22 Jan 2013 17:09:50 GMT alec1982 2013-01-22T17:09:50Z Calculation in a text box https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445112#M166038 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I am trying to do some calculation in a text box.</P><P></P><P>the expression looks like:</P><P></P><P></P><P>= Sum({1}Sales)/Sum({1}EmployeesCount)</P><P></P><P>I have used {1} so the list boxes dont effect the calcualtio as i am looking at average.</P><P></P><P>Now I want to apply one filter all the time as follow:&nbsp; I want this text box to show the same calculations but for three cities where I have a list box named city</P><P></P><P>City </P><P>Atlanta</P><P>NY</P><P>DC</P><P></P><P>Anybody can help..</P><P></P><P>Thxs</P></BODY></HTML> Tue, 22 Jan 2013 17:09:50 GMT https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445112#M166038 alec1982 2013-01-22T17:09:50Z Re: Calculation in a text box https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445113#M166039 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>= Sum({1&lt;City = {Atlanta,NY,DC}&gt;} Sales) / Sum({1&lt;City = {Atlanta,NY,DC}&gt;} EmployeesCount)</P></BODY></HTML> Tue, 22 Jan 2013 17:18:29 GMT https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445113#M166039 swuehl 2013-01-22T17:18:29Z Re: Calculation in a text box https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445114#M166040 <HTML><HEAD></HEAD><BODY><P>Thxs so much!</P></BODY></HTML> Tue, 22 Jan 2013 17:45:32 GMT https://community.qlik.com/t5/QlikView/Calculation-in-a-text-box/m-p/445114#M166040 alec1982 2013-01-22T17:45:32Z